Results 1 to 4 of 4
  1. #1
    ixthus78 is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2009
    Posts
    2

    Question Prompting both when opening and printing report

    I have a report I run that asks for date parameters and then asks to enter a running total number. However, it asks me for the running total number AGAIN when I Print the report. I have checked the VBA for the form it is using and the spelling is correct and the same in all instances. What can I check now?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It sounds like the prompt is coming from the query for your report. The query runs when you preview and again when you print.

  3. #3
    ixthus78 is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2009
    Posts
    2
    I found the problem. The control name was different between the form and the query it was running. THX!

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Excellent! I guess you are ready to follow the link in my sig to mark this thread as Solved then, right?

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

Similar Threads

  1. Replies: 2
    Last Post: 07-28-2014, 01:15 PM
  2. Help with my printing
    By mattwill2001 in forum Queries
    Replies: 4
    Last Post: 08-17-2009, 01:55 AM
  3. Replies: 16
    Last Post: 06-03-2009, 07:01 AM
  4. Report Printing Error
    By gjohnson71 in forum Reports
    Replies: 4
    Last Post: 03-07-2009, 12:36 PM
  5. Replies: 0
    Last Post: 04-26-2008, 09:59 AM

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