Hi Mark
This might be a little late now, but I had the same requirement as you yesterday. I searched a load of forums and didn't find an answer. However I had a brainwave last night that worked this morning and the result is exactly what you are after and the great thing is it is a simple solution.
On your order form you will need a primary key (or a unique piece of data). When you fill in the order the order itself will be assigned this key field (or unique piece of data). The query that drives the report will need to point to the key field (or unique piece of data) as the criteria of the query.
For example - my order form is called OrderForm. My Primary Key is called OrderNum. So the query that drives the report for the invoice will need to reference my OrderNum on the OrderForm.
Ensure that the primary key (or unique field),in my case OrderNum, is present in the query that drives the report. The criteria for OrderNum in the query:
[Forms]![OrderForm]![OrderNum]
Save the query - ensure that it is this query that is driving your report and your report will only report on the active OrderNum from the OrderForm.
Hope this helps.
Debbie
Enter your message below
Sign in or Join us (it's free).