passing query parameters from within form to get results in a subf

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query defined that accessses many sql datasets and does some
calculations. This query requires 3 inputs (item, lot, whse). How can I set
up my form/subform to provide input boxes for these fields and then use the
fields in the query to get the output in the subform.
 
Did you search the group for your answer first? This is posted all the
time.

Create your form, then use the following as your criteria in the query...
Forms!SomeFormName!SomeFieldName
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help on how to pass calculated field from a form to another form 0
Passing query parameter from form 4
perplexed on query from form 12
Parameter Value error in a Subform 0
Query in a sub form 1
Blank Query Result in a Sub-Form 6
Form-Entered Parameters for Pass-thru query 1
Data from a subform into a query 2

Back
Top