Check Box Display problem

[Phideaux]

I need to find a way to cause a form not to display if a check box on the form is checked. I only need to have the box show up once and if the box is not checked stop the program from operating untill the box is checked. It's for a EULA agreement at the first opening of the DAta base. I'm using Access 2000 and the program is nearly ready to distribute.

Any Ideas??

THanks in advance for the input.

Phideaux

The mind is the best toy.
Play with someone else's often

 

[jimb0ne]

the best way to do this is edit the database startup properties when the user clicks the checkbox. So in the onclick event of the checkbox have something like this...

if checkbox1.value = -1 then 'it is checked
currentdb().properties("StartupForm&quot = "none"
else
currentdb().properties("StartupForm&quot = me.name
end if

then in the onload of the form, have the following code,

if currentdb().properties(&quot;StartupForm&quot <> me.name then
'open whatever form you want if they don't view the EULA here
me.close
end if

that should do the trick