Remember Me.

[alex]

Hello all,

Using Access '03...

I have several checkboxes on a form. These controls hide/unhide
columns on a subform.

If a user leaves (for e.g.,) 3 columns visible when he/she exits the
database, those columns remain visible when the user reenters the
database--this is a good thing.

Problem is, however; Access does not remember that a particular
checkbox was checked. I.e., the user enters the forms, sees the
columns that he/she left visible, but all the checkboxes are
empty...causing confusion.

Is there a line of code that will tell Access to hold the value of
checkbox upon exiting?

Thanks,
alex

 

[Arvin Meyer [MVP]]

You would need to store the value in the table to make it persistent.

 

[alex]

You would need to store the value in the table to make it persistent.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com












- Show quoted text -

Thanks Arvin for your help...must the value be stored in the same
table that the original form is tied to, or can the values be held in
a seperate table?

 

[Arvin Meyer [MVP]]

Thanks Arvin for your help...must the value be stored in the same
table that the original form is tied to, or can the values be held in
a seperate table?