Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012

    Unanswered: Open report by CustomerID

    I have a button on the customer form. I am trying to open the report "Invoices" and have it show that customers invoice. I assume I have to refer it to the CustomerID somehow but not sure. If I use the code:

    DoCmd.OpenReport "Invoices", acViewPreview, , "CustomerID=" & Me.CustomerID
    It will only open the first record with an invoice#

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    What is the data type of CustomerID? If it's not numeric:

    Open a second form to the record

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts