Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

getting a queries criteria to lookup a value in a form

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
i have to run a query in the backend of a database however i need the criteria to lookup a value in a form from the front end of the data base.
i have tried using the build feature however im not sure if there is a function within this that can lookup a textbox in a form from another database.
 
You need to set up a sub-form and place it inside your main form. Attach your backend query of course to your sub-form. If you are looking up values in your front-end database and you want you BE to lookup values based on a FE value, then in the criteria for your BE query, put in: [FORMS]![FE FORM]![FE control name]

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top