Search Form -- Combo box, text field

[DavidCdp1]

Hi Everyone,

Please help me. I have a form with a combo box and a text box. The values in the combobox is the names of the fields in a table. When I select a value in that combobox then I input search criteria for that field ( value of column) like john or smith or allen in the text box and click on the search button. I have list box in the form with row source as
SELECT [Consultant Table].Consultant_ID AS [ConsID],
[Consultant Table].Surname,
[Consultant Table].First_Name,
[Consultant Table].Nationality,
[Consultant Table].Process_Status
FROM [Consultant Table]
WHERE ((( [Consultant Table].&Forms!Search_Form1!combo0&) Like
"*" & Forms!Search_Form1!text2 & "*"))
ORDER BY [Consultant_ID];

When I run the form, it is giving errors/problems.

Please help me.
Thanks
DavidCdp.

 

[Uncle Gizmo]

Try some think along these lines :

>>>>> WHERE ((( [Consultant Table].&Forms!Search_Form1!combo.[Column](1)&) <<<<<