Enable controls when form loads in If statement

[Ashe]

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!

[ssanfu]

From your naming of the control, it looks like "Me!lstRegulation" is a list box. What is the value of the list box when the form loads? Try this:

Private Sub Form_Load()
Me!cboProject.SetFocus

msgbox Me!lstRegulation  ' <<--

If Me!lstRegulation = "Yes" Then
cboRegulation.Enabled = True
End If

End Sub

Is the bound column of the list box a text field? And there are entries with the word "YES"?

[Ashe]

Yes- lstRegulation is a bound list box. The value is the list box will either be "Yes" or "No." In instances where lstRegulation=Yes, the combo box cboRegulation should be enabled.

Using your suggested code, the box is now enabled when lstRegulation=Yes, which is great! Except, I have the message box popping up with "Yes" as the message. Is there a way I can suppress that?

Thanks for your help!

[ssanfu]

Comment out or remove the line

msgbox Me!lstRegulation  ' <<--

[Ashe]

When this line is removed, cboRegulation is not changed to enabled.