Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2004
    Location
    Regina, Saskatchewan, Canada
    Posts
    17
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Using a parameter query form in a report. (MS Access 2003)

    Hi! I have created a form the is used as a parameter query and is linked to a report. Everything seems to work ok except that the report is printing to screen as a datasheet rather than in the format that I originally created for the report. Is this normal for Access- that is using a form that refers to a query causes the report to automatically print in datasheet format rather than the format created in the report?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Using a parameter query form in a report. (MS

    No it is not normal.
    It sounds to me like you are opening the query rather than the report.
    Do you open the report using a command button on the form? What is the code behind the button?
    Regards
    John



  3. #3
    New Lounger
    Join Date
    Jan 2004
    Location
    Regina, Saskatchewan, Canada
    Posts
    17
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Using a parameter query form in a report. (MS

    Thank you for your prompt response!

    After a good night's sleep and your comments, I reviewed the coding (which I copied from another application) and found that there was one reference that I had not corrected to my database. The process seems to work fine now.

    As your comments made me re-think what I had done and convinced me to check for the fourth or fifth time what I had done, I again, thank you for your response.

Posting Permissions

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