I have two strings that I would like to incorporate into a search function.

Dim StringText As String
Dim StringCombo As String

StringText = Form1.SearchString
StringCombo = Form1.ComboSelect

*******Gold.RecordSource = "select * from Gold " & _
"where " & StringCombo & " = '" & StringText & "'"***********


Gold.Refresh
Form1.Hide


That is what I have as my search Button Function. Now where the astrerisk are is where i am having a problem. I want to be able to search in my database called Gold in the Table and in the Category that is listed in my ComboSelect Box. I am looking for what is in the StringText Variable. If that makes sense at all. I hope it does. I want to make this search feature available for all my categories not just one section of it.