I have a form and a sub form. Lets call the form personal details and the subform contract details. Linked in a one to many relationship, personal to contract.
Now the form is open with the personal details being displayed and the sub form showing all the contracts for that person.
Now how do I pass a value to a query to print out the subform details automatically in a report, i.e without having to type something into a dialog box.
I want to click the button and let it do the work.
Any help would be appreciated as with my limited access skills, this quite frankly is "doing my head in"