Need to set value for a field in a query - TechRepublic
General discussion
June 7, 2000 at 09:38 AM
cynder

Need to set value for a field in a query

by cynder . Updated 26 years ago

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.

This discussion is locked

All Comments