Hi all
I have a main form holding job details with a autonumber as the jobnumber.
on the page is a subform holding item details.
When i print the form from a query I am getting all the subform details for the other jobs showing as well
What is the best way to setup the form/subform relationships and query/print
so I only print the details for that that job sheet. (the current page open)
I will send some snap shoots tomorrow of my form and print form if this helps
many thanks for any pionters
I have a main form holding job details with a autonumber as the jobnumber.
on the page is a subform holding item details.
When i print the form from a query I am getting all the subform details for the other jobs showing as well
What is the best way to setup the form/subform relationships and query/print
so I only print the details for that that job sheet. (the current page open)
I will send some snap shoots tomorrow of my form and print form if this helps
many thanks for any pionters