slc193
Jun 4, 2009, 11:40 AM
I am using Access 07. I have an invoice form and a I have created a query to find invoices of specific criteria. How do I make it so that I can click on a record in the query (or report based off the query) and it opens the invoice form and goes specifically to that record to review or edit it? TIA.
ScottGem
Jun 4, 2009, 12:13 PM
Reports and queries are not interactive. You need to use a form instead. Create a form in continuous form mode bound to the query. You can then use the On Double Click event of invoice number control to open another form with that record by using the WHERE clause of the OpenForm method. Something like:
Docmd.Openform "formname",, "[InvoiceID] = " & Me.InvoiceID