Hi everyone
I'm battling with a query. I've got tables (InvoiceT and CustomerT) with fields in the Query as seen in image. I want the Query to only display data from a specific InvoiceID. I entered forms![InvoicesF]![InvoiceID] under criteria and when I run it it works. Problem is: How do I get the Query to display this info when I click on a field called [InvTotal] on a form called InvoicesF ?
I've attached screesnshots of the forms I'm using and the Query.
Your Guidance will be appreciated