Hello again,
I have created a search form based upon Allen Brownes search code - http://www.allenbrowne.com/ser-62.html
I have it up and running and the text search box's work brilliantly, but I now wish to add a combo box into the criteria string, which is causing me problems. My code is
If Not IsNull(Me.cboBiaName) Then
strWhere = strWhere & "([BIA Name] = "" & Me.cboBiaName & "") AND "
End If
I have the combo box in the header, which when clicked shows the correct list, but once a criteria is selected search brings back no records. If I leave it blank and enter criteria in the other text search boxes the search runs correctly.
The database is made up of 3 tables a main table, which the search form is generated from and 2 list tables.