Formatting a form before it is opened

[simonI]

hopefully someone will know what to do...

i have a form that has a bunch of check boxes and labels that are hidden to start with,and become visible when a confirmation button is pressed. Wen i set this up in the design view i.e making their visible status = false, everything runs accordingly - however when the next person comes to update their details the form will not format properly. i think the reason has something to do with the check boxes having different visibilty statuses after the initial confirmation i therefore used code on the form open event

If Check2.Visible = True Then

check.Visible = False
End If

however this tends to fail at the first checkbox, however if i then press run on the VBA screen everything else seems to then run fine and so only the first checkbox is left visible...

can anybody help....

thanks in advance i hope i have made myself clear..

 

[Sergeant]

If you are not closing the form between users, try putting your code in the OnCurrent event of the form instead of OnOpen.

 

[simonI]

thanks but the form is being closed between users...

any other ideas?