How to Open the Same Report With Criteria from a Form Field or a Prompt in Microsoft Access

In this Microsoft Access tutorial, I will show you how to open the same report using either a form field or a prompt for criteria. You'll learn to remove dependency on a pre-opened form by integrating an input box, applying a Where condition, and enhancing user prompts without complex coding. This tutorial will make your Access reports both user-friendly and versatile.

Samantha from Clinton, Oklahoma (a Silver Member) asks: If I open an invoice report while the order form is open, the query uses Forms!OrderF!OrderID to get the currently open invoice to display. Is it possible to open an invoice from the Main Menu form without having the order form open but also not having the user see that unfriendly prompt? Maybe give them something like "Enter Order ID"? - Paraphrased

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

RECOMMENDED COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database,, report criteria from form, form field criteria, user prompt criteria, input box for criteria, where condition in Access, custom query criteria, VBA programming Access, dynamic report generation, user-friendly Access forms, create accessible database inputs, validate numeric input Access, DLookup function usage, Nz function example, error handling in VBA, dynamic SQL conditions Access, Access report customization

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[Shadow.Dragon]

Thanks for the great video, Richard! I also wish my "younger" self had commented his code! LOL!!!

[josephpatrick]

Thanks for covering the minute details.

[ajitjohn]

Great video myself a beginner. I want to know what will be the scenario in the case of a report based on a parametric query and the parametric field is not included in the report

[youknow]

After making some mistakes and adding additional options to various versions in BASIC, this was my solution REM PROGRAM NAME "INVOICE" 11/13/92 REV D (yes this was from 1992)