Reporting (Access XP)

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

Thank you, Hans. That did the trick.

Reply | Quote