Filtering Records

[Alex Motilal]

I do have a Form which displays the list of all the employees.


I want to set an unbound combo box having field values of F & M
On selecting the M, the list should display Male employees & vice versa.

Regards
Alex

[ranman256]

put this code in the after update event to filter the gender....

'----------------
sub cboSex_AFTERUPDATE()
'----------------
If IsNUll(cboSex) Then
  Me.FilterOn = False
Else
  Me.Filter = "[Sex]='" & cboSex & "'"
  Me.FilterOn = True
End If
end sub

[Alex Motilal]

Thanks Ranman.
Your solution Worked.
Alex