[AccessD] Looking for easy form solution

[Rocky Smolin]

Make the default value in the table False.  You may have to run a quick
update query one time to set the value of the added field to False in  the
existing records.  But all other records which are added should set that
field to false as default. 

r

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of FW
Salato Center
Sent: Saturday, October 24, 2015 10:03 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Looking for easy form solution

You know, if you don't work with Access frequently, you forgot a lot -- at
least I have. 

I added a Yes/No field to the Individual table and left the default value
blank. I don't want to set it to Yes by default, it just seems dangerous
since I won't be using it any other way. So, in the form, I set the
control's Default Value to -1. Didn't work -- when the form opens, the
Select Yes/No field is still not selected. I tried code when opening the
form -- still not setting the field to Yes. 

It's a Datasheet form. This should be simple. It's based on a query, but for
no other reason than good form -- it isn't a multi-table query. 

Susan H. 


Forgot - o the form where the individuals are displayed you also need a
checkbox bound to the deselect flag.   :)


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus