check box value to remain even if form is closed

[sooli]

I have a check list in my database that is not actually tied to any record source, its just a check list for the user to use as a visual aid as they complete a sequence of tasks. These tasks may be spread over a day or two as there are several of them and they are time consuming. The idea of the check list is to keep track of what has been completed w/out using a piece of scratch paper.

I want the check box to remain checked even after the form is closed, so when they open the form again, the checks they made last time are still there.

I have a button that will clear the checks when the sequence is started again.

I see no reason to create a table to keep these since the data is not static, nor is it required by anyone other than the viewer.

I tried to set the default value to 1 on the click event, seems that would be the logical step - but it isn't working...

If Check73.Value = 0 Then
Check73.DefaultValue = 1 
Else
Check73.DefaultValue = 0
 
DoCmd.Save
 
 

i did try -1 as well and still when i close the form, all the checkboxes are rest o "unchecked"

thanks for any suggestions...

[Seth Schrock]

I think that it would honestly be easier to create a table. You mention that it is only for the viewer. This leads me to think that you have a front end/back end setup for multiple users. If this is the case, then you can make this table on the front end so that it is only on the user's computer and no one else sees it.

If the database can close in the middle of a task (like when they go to lunch or the computer crashes), then a table is the only way to save this information. The only other viable way that I can think of to do this would be to use temporary variables (tempvars), but then you have to code the link instead of letting access take care of it.

[jforbes]

I agree with Seth that a Table is the way to go.

I see no reason to create a table to keep these since the data is not static, nor is it required by anyone other than the viewer.

It may not be required by anyone but the viewer, but it is Static as you are expecting the checkboxes to retain their value between instances. I would create a table and include a UserName as a column, then include the UserName as part of the Filter for the Query. That way everyone has their own set of rows.

[sooli]

Ok... well... i was hoping to avoid that, in order for me to set it up the way I need it set up, i am going to need a table with 170 variables that can be checked or unchecked! my poor fingers!

[Seth Schrock]

It would be even worse for your fingers using code. Good luck on your project and let us know if you run into anymore problems.