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
 
Back
Top