I am working on a form, and have a bunch of controls that I want to change their visibility based on a check box. If the check box is true, then I want to show the controls, if it is false, I want them to be hidden.
I can get this to work, but my problem is when adding new records. If my checkbox value is true, and my controls are visible. When I click a command button to add a new record, the new records checkbox is also true. The controls are displayed. By default I want it to be false, and the controls to be hidden.
If I then manually change this checkbox to false, and go back to my previous record (where it was true) then it is now false.
What is going on?
Thanks.