Hi,

I have a form which has a table as a record source , I have 4 combo boxes (FName,LName,City,Country)on my form with a rowsource of 4 different fields in the table, what I would like is that when a user makes a selection in the combo boxes the form filters accordingly.I can do this by changeing the record source on the after update event on the combobox, however I want the form to filter on any of the comboboxes, eg. if a user makes a selection in FName and City then it should show all those records or alternatively if the user makes a selection on Country only it should change the record source accordingly.I am trying the following code but the problem is that it assumes the other combo boxes have selections, please let me know if this doesn't make sense, any help would be greatly appreciated.
Thanks

Dim strSQLSF As String
strSQLSF = " SELECT * FROM tblMainData "
strSQLSF = strSQLSF & " WHERE (tblMainData.FName = '" & cmbFName & "' or Isnull(Forms!formname!cmbFanme) ) And "
strSQLSF = strSQLSF & "( tblMainData.LName = '" & cmbLName & "' or Isnull(forms!formnname!cmbLname))And "
strSQLSF = strSQLSF & " (tblMainData.City = '" & cmbCity & "' Or Isnull(forms!formname!cmbCity)) "
Me.RecordSource = strSQLSF