Text Values from forms in SQL queries

[aggiematt]

Is there a way to reference values from textboxes on Access forms in SQL queries?

 

[PHV]

Provided the form is open when the query is launched:
Forms!NameOfForm!NameOfTextBox

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TomCologne]

You'll find plenty in the FAQs here, eg
"How to dynamically build a query from controls on a form".

Each forum has its FAQ tab with a lot of valuable information and I recommend a visit.

TomCologne