The comb box will have the list of fields. (And delimiter)
the text box will allow user to enter the search word.
A button will open the query.
Note: the combo box will need 2 fields: 1 to show the field name, 2 to have the delimiter.
strings will have a single quote.
numbers will be null.
dates will have #.
The form is continuous form that shows all records.
the button click will filter via code....
Code:
sub btnFind_click()
vDelim =cboBox.column(1)
Me.filter ="[" & cboBox & "]=" & vDelim & txtBox & vDelim
me.filterOn = true
end sub