[AccessD] Looking for easy form solution

[FW Salato Center]

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