I have a form with a subform. In the subform is a work order number. I would like to use the work order number in the criteria for a query. That way I can tell it to print a report in the form and it will print the report that goes with the form currently being viewed. I can get the report to print correctly but it always asks me for the work order number instead of pulling it from the subform. What do I enter into the criteria in the query to make it pull the info from the subform. Is it different for subforms compared to mainforms?
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!
Report based on subform
- Thread starter mcginnism
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
