I have a Access (mdb) file containing fiedls Name, Father, Mother, Regd, Contact i connected with with vb6
in vb form there is a text1 textbox for search record from above fields and
to select category to search i put a comboBox (containing list Name, Father, Mother, Regd, Contact)

I am using this command to search record from field :

Data1.Refresh
Data1.RecordSource = "select * from table1 where table1.NAME like '" & Text1.Text & "*'"

This command search record from name field,
i want that when combo1 change the field of search from name to Father, mother or ID etc.
How can i do it, plz create and attach vb example if anybody has
Thanks in advance.