C
cameron sutherland
It sounds like you are closing and opening the form which
is resetting it. if this is the case you can try one of
the following:
1. Put each check box value in a global variable which is
declared in some Module outside of the form.
2. If the form is unbound then bind it to a table with
boolean values for each check box. NOT A GOOD SOLUTION FOR
MULTIPLE USERS but this has the advantage of remembering
the selections even after you close and open the file. If
the form is already bound you can set values (DAO, ADO...)
in your code.
3. Instead of closing your form change your code to hide
it and make it visible when you want to open it again.
This way the checked values persist and you get the added
value of less flicker when the form load vs shows.
-Cameron Sutherland
field disappears. I have all check boxes set so
that "after update", if the box is checked the other field
disappears. The problem is, when I go back to that record
all of the invisible fields have reappeared. Is there a
way that I can keep the fields invisible (or visible)??????
is resetting it. if this is the case you can try one of
the following:
1. Put each check box value in a global variable which is
declared in some Module outside of the form.
2. If the form is unbound then bind it to a table with
boolean values for each check box. NOT A GOOD SOLUTION FOR
MULTIPLE USERS but this has the advantage of remembering
the selections even after you close and open the file. If
the form is already bound you can set values (DAO, ADO...)
in your code.
3. Instead of closing your form change your code to hide
it and make it visible when you want to open it again.
This way the checked values persist and you get the added
value of less flicker when the form load vs shows.
-Cameron Sutherland
so that when a check box is selected, a corresponding
field disappears. I have all check boxes set so
that "after update", if the box is checked the other field
disappears. The problem is, when I go back to that record
all of the invisible fields have reappeared. Is there a
way that I can keep the fields invisible (or visible)??????