Hello
I have a form that brings up a selected record chosen by the user (from a separate filter form).
Some controls are enabled/disabled based on other control values. The dependent controls are disabled by default and I am using an if statement to re-enable them. When the form loads a record, I would like it to read the control values and enable some controls based on what is currently in the record. I must be missing a step, because the my If statement is not enabling any of these controls.
This is just an example for one control box that I've been testing:
Private Sub Form_Load()
Me!cboProject.SetFocus
If Me!lstRegulation = "Yes" Then
cboRegulation.Enabled = True
End If
End Sub
When the value in lstRegulation is Yes, cboRegulation remains disabled.
I tried using Me!lstRegulation.value= "Yes", but to no avail.
Any idea what I'm missing?
Thank you!