[AccessD] Looking for easy form solution

Rocky Smolin rockysmolin at bchacc.com
Sat Oct 24 10:16:10 CDT 2015


You won't have to requery.  When you set the filter in code it does a
requery.

r

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

Rocky, I considered adding the Yes/No field to the individual table, but
it's only use would be for updating the flock/herd stock. It certainly would
be easier than anything else I've come up with. I put it aside because it
kind of breaks normalization rules, but the truth is, I break them when
doing so suits me, so I see no reason not to take this easier route. I did
explore alternatives, but I keep coming back to this. 

I hadn't considered refiltering the form based on the select/deselect field
-- but visually, I suppose it might make the user feel better. I would be
using the field to update or not update. Do you guys thing requerying for
visual impact is important to the user -- it might be. 

Susan H. 



How's this? 

Add a "deselect" flag to the animal record - default False.  

On the form where all the animals are displayed a toggle Show
Deselected/Don't Show Deselected.  Then Don't Show is selected, add a filter
to the form to filter out the deselected animals. 

Any possibilities there?

r


--
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



More information about the AccessD mailing list