Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reporting (Access XP)

    Good Morning All:

    Attached is the problem database. The report, rpt_Individual_Contacts, is a main report with several subreports. When the report is executed, an 'Enter Parameter Value' Input Box appears. Clicking okay allows the report to run successfully, but I need to have that input box not appear. I have run out of places to look and I need another set of eyes to assist. Thanks in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Reporting (Access XP)

    You have included the ContactID field twice in the query qryIndividualContacts. This is confusing, you should only include the one from tbl_Contacts.
    You should then remove the text box tbl_InquiryTypes.ContactID and its label from the report.
    See attached version.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reporting (Access XP)

    Thank you, Hans. That did the trick.

Posting Permissions

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