Results 1 to 4 of 4
  1. #1
    tkkt is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    2

    Angry Opening report with macro

    Hey guys! I've been racking my brain on what feels like a tiny mistake.
    I have an invoice with a combo box, it is used to choose which customer I want. I also have a button with a macro attached to it that print the report. So here is my problem...
    The records update when I click through the customers, but when I go to print that specific invoice it shows all the records I have in the tables. None of the information is updated at all. Let me know if you guys need any other information! Thank you

  2. #2
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I don't use macros, but are you telling the report which specific record to print??

  3. #3
    tkkt is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    2
    Yes I specified in the macro using WHERE [Customer ID]=[Forms]![The form I am trying to print from]![Customer ID]. Do you think that is right?

  4. #4
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    That sounds correct.

    In VBA you could step through the code to see if the [Customer ID] from the form is being picked up correctly. Don't know how to do that in a macro.
    Maybe add a message box before the Print command to display the [Customer ID].

    Do you want to post your dB for analysis?


    BTW, shouldn't use spaces in object names.... CustomerID or Customer_ID would be better.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Macro to Change label before opening Form
    By Brigsy29591 in forum Macros
    Replies: 3
    Last Post: 09-01-2015, 09:08 AM
  2. Replies: 3
    Last Post: 01-30-2015, 01:52 PM
  3. Error with macro while opening access.
    By Trisha in forum Access
    Replies: 5
    Last Post: 03-04-2014, 01:07 PM
  4. Replies: 9
    Last Post: 02-04-2013, 03:22 PM
  5. Another Problem opening a report using a Macro
    By clchris_80 in forum Access
    Replies: 1
    Last Post: 01-18-2013, 08:01 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums