Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Go to specific record from report (https://www.askmehelpdesk.com/showthread.php?t=361388)

  • Jun 4, 2009, 11:40 AM
    slc193
    Go to specific record from report
    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.
  • Jun 4, 2009, 12:13 PM
    ScottGem

    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

  • All times are GMT -7. The time now is 12:27 PM.