Open a Report with Criteria from Form or a Prompt

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

Members

There is no extended cut, but here is the database download:

•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Invoicing
• InputBox

Links

• If Then
• NZ Function
• DLookup
• Open Report

Recommended Courses

• Access Developer Courses
• IsNumeric in Access Expert 25

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, 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