Hi, Jared.

First, I recommend you use Richard's naming convention. So if "RequestType" Is a combo box; it should be named "RequestTypeCombo".

The if statement you need will look like this:

If IsNull(RequestTypeCombo) then

Jared

I would write the VBA Code of IsActive as follows:

Private Sub IsActive_AfterUpdate()

If IsActive Then
     FamilySize.Enabled = True
     CustomerSince.Enabled = True
     CreditLimit.enabled = True
Else
     FamilySize.Enabled = False
     CustomerSince.Enabled = False
     CreditLimit.enabled = False
End If

You will also need to add this code to the Form OnCurrent Event.

Jared

For a ComboBox, you can use what Sami put above... and/or you can also make fields inactive based on options in your combox.  (assuming you set those up the way Rick suggests):

If RequestTypeCombo = X OR RequestTypeCombo = Y  OR RequestTypeCombo = Z Then
     FamilySize.Enabled = True
     CustomerSince.Enabled = True
     CreditLimit.enabled = True
Else
     FamilySize.Enabled = False
     CustomerSince.Enabled = False
     CreditLimit.enabled = False
End If

Again.. add this to your Form OnCurrent Event.

Jared

Another more advanced option you could incorporate:

In the Table for your ComboBox options... add a Field called 'EnableFields' and make this a boolean field.  Now you will be able to set which combo box selections will be used to enable fields.  You will need to either manually update this field in the Table for what your want, or add this Field to the Form you use for your ComboBox options.

When you add the ComboBox to your form, add this field to the Row Source, then set the Column Width for this field to 0" (so it's not shown).

Now your VBA Code can look like this:

If RequestTypeCombo.Column(X) Then
     FamilySize.Enabled = True
     CustomerSince.Enabled = True
     CreditLimit.enabled = True
Else
     FamilySize.Enabled = False
     CustomerSince.Enabled = False
     CreditLimit.enabled = False
End If

' RequestTypeCombo.Column(0): this is the first option in the combo box
' RequestTypeCombo.Column(1): this is the second option in the combo box
' RequestTypeCombo.Column(2): this is the third option in the combo box
' etc....

Again... add this to your Form OnCurrent Event.

Thank you Sami and Raymond! Your recommendations have been very helpful.