[AccessD] Looking for easy form solution

[FW Salato Center]

The other problem is how to set the procedure or vaccine for all of them. Can't use a subform in a Datasheet view form. Well, I suppose you could, but in this case, that would be silly. ;) 

Susan H. 

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

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