Hi All
Sorry to bother everyone with a newbie question, but I could really do with some help.
I am creating a database which tracks outstanding invoices by customer. I have a query which filters for only unpaid invoices, and this is displayed as a subform in a form which has the customer name and account number on it. It enables me to see all outstanding invoices by customer.
I have another form in which each record is an individual invoice, and it has a subform within it which tracks "Chasers". So everytime payment is chased, a record is entered to keep track of when the invoice was traced and what the outcome was.
What I would like to do is double click the invoice number on the first form, and for it to then open the other form filtered by that invoice number.
I typed in the following code
DoCmd.Openform "frm_ProformaInvoices",,,"Sales_order =" & Me.Sales_order
All I get when I run it is a pop up box asking for a value
Where am I going wrong?
Appreciate any advice