How do i make a subform thats controlled by another subform though? I'm using access 2007 and the wizard is not giving me the option of using the invoice subform to control the new invoicedetails subform.
Ok guys i think there was a minor problem with something i'm not sure what but it seems to work now. I can change CaseID to view different Cases and change INvoice ID to view different invoice details. THanks for your help.
A quick query for you regarding printing current records. I had a button set up using the code:
This displayed all invoices for each case. My question is, how can i adapt this so that it sends the current invoice's details to the report? I did try changing the values in the code but to no avail. Thanks