Enabling / Disabling Controls by Checkbox

[allamaria]

I am creating a form in Access, in the form there is a checkbox and some fields. I want to set the checkbox so, that if the user clicks on it, the fields should be enabled, if the checkbox has not been clicked, thann the fields remain disabled.

Could you please help me to write the VBA-code for this procedure?

Thank you!!

Alla

[nico5038]

Best to use the .tag property of the formcontrols.
atJust mark the fields the should be enabled with a "E" in the .tag property (under the Other tab of the property popupform).

Now you can use this code in the OnOpen event of the form and the AfterUpdate of the checkbox:

 
dim ctl as control
 
for each ctl in me.controls
    if ctl.tag = "E" then
      if me.checkboxfield then
         ctl.enabled = true
     else
         ctl.enabled = false
     endif
   endif
next
 

Getting the idea ?

Nic;o)