I am trying to filter records in a form using two combo boxes
with the following in the after update event of each:

If IsNull(Me.cboFilter1) And IsNull(Me.cboFilter2) Then
Me.FilterOn = False
Exit Sub
End If

If IsNull(Me.cboFilter2) Then
Me.Filter = "AreaID = " & Me.cboFilter1
Me.FilterOn = True
Else
Me.Filter = "AreaID = " & Me.cboFilter1 & _
" and EquipmentNameID = " & Me.cboFilter2
Me.FilterOn = True
Exit Sub
End If

However, when I select cboFilter1 my EquipmentNameID
field goes blank and I cannot figure out why?  Does anyone
have any suggestions?  The filter works fine, by the way,
just a blank box.