R
rc51wv
I want the users to be able to search tblCell. It has 14 columns. I only need
3 of these to be searchable. I need to be able to have the user enter the
information that want to search for in a text box and be able to choose
either of the 3 searchable fields in a combo box. I have the text box set up
as txtSearch and the combo box set up with the names of the fields I want
searchable as cboCriteria.
How do I go about setting it up so when the user enters information to
search for in the text box and selects the criteria, it lets them view all 14
fields of the table for the field that contains a match to the query.
ex. 50 fields in the table have the reference number 333000. When the user
selects reference number from the criteria and enters 333000 it returns all
the entries with all the fields for 333000.
3 of these to be searchable. I need to be able to have the user enter the
information that want to search for in a text box and be able to choose
either of the 3 searchable fields in a combo box. I have the text box set up
as txtSearch and the combo box set up with the names of the fields I want
searchable as cboCriteria.
How do I go about setting it up so when the user enters information to
search for in the text box and selects the criteria, it lets them view all 14
fields of the table for the field that contains a match to the query.
ex. 50 fields in the table have the reference number 333000. When the user
selects reference number from the criteria and enters 333000 it returns all
the entries with all the fields for 333000.