Reference query field

[Aerowolf]

I have a form where the user enters the sales order number and then hits a "Print Labels" button.
The button opens qryVAN00 which queries the sales order table and filters it based on the sale order number entered.
For each record in the query I need to grab the value in the ItemKey field and then open a report to print the label for that item.
How do I reference the ItemKey field in the query to be able to do this?

Thanks
Edwin

 

[tasawer]

is your report ready to be printed?
are there more records than one for every sale order number?

you can get the query to filter all records related to Sales Order Number and print all labels in one go.
Otherwise, you can display the filtered query in a subform and select the appropriate record to print.

let me know if you have not sorted it by now