Enable a combo box if

[Guest]

I have a combo box That I would like to enable if certain fields in my form
have been entered e.g., the text fields -Name, Address, combo boxes-source of
information, reason of application and finaly at least one of the checkboxes
should be selected.

The checkboxes have a tag in them already....

 

[John Vinson]

I have a combo box That I would like to enable if certain fields in my form
have been entered e.g., the text fields -Name, Address, combo boxes-source of
information, reason of application and finaly at least one of the checkboxes
should be selected.

The checkboxes have a tag in them already....

You can use the Form's Current event to check the values in fields and
set the Enabled property of the combo box appropriately. Your posted
criteria are a bit vague so I can't suggest the exact syntax, but it
might be something like

Private Sub Form_Current()
If Me.NewRecord Then
<set the enabled property appropriately for new records>
Else
If IsNull(Me!txtName) Or IsNull(Me!txtAddress) Then
<do something>
Else
<do something else>
End If
End If
End Sub


John W. Vinson[MVP]