I neeneed to be able to set the value for the field in a query. I want the user of the program to be able to choose the field he wants to search through a combo box.
WHERE [tblBugs].[=[frmBugEntry]![FieldList]] = [frmBugEntry]![TextSearch]
The above code was taken form the Accesss2k SQL view of the query. I am at a comlete loss here so any help you can provide for the few points I have offered would be appreciated.