All of the fields in the report are then generated from the associated IDENT NO.

As it currently stands, when I open the report, it will create a single page report for each ID number in the Report Data table when opened.

Then, after the user has entered that number, youll need to re-set the source of the report.

Instead of Select from MyQuery, set it to Select from MyQuery where IDENTNO MyPopupForm.MyText.Text.

Additionally, I have changed the ReportName to its actual name, however I am unsure about the specific name of the IDENT NO since I didnt create this report, but was just tasked to create the filter for it.

IS there a place where I can find the actual name for the IDENT NO.

This same thing can be done in a report by entering IdentNoVariable into the part of the report where the entered value is desired.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged vba ms-access ms-access-2010 or ask your own question.

The Button runs the report, and the report refers back to the form by name to get the start date and end date.

The button runs the report but sets the appropriate filter via the docmd.openreport command.

Access will automatically prompt for those parameters one by one.

First off, if you want to run the report without parameters, you dont want to define them in the recordsource of the report.

This is also the problem with your first suggestion, which would tie the report to the form (from AccessJets point of view, there is little difference between a PARAMETER declared in the SQL of the recordsource and a form control reference; indeed, if youre doing it right, any time you use a form control reference, you will define it as a parameter).

To do that, youd open the form where youre collecting your dates using the acDialog argument, hide the form after filling it out, and then write the recordsource on the fly.

If the criteria are set, then I write the SQL for the recordsource on the fly, if they arent set, I just use the default recordsource (and any filter passed in the OpenReport argument).

In this setup, you would run the report only after youve collected the criteria and set up the class module instance.

The advantage of this approach is that the report can be run in either of the two contexts, and none of the parts need to know anything about each other -- the report simply needs to understand the class modules interface.

If your locale doesnt use dates in the US format, then youre going to get some nasty surprises.

I always use a DateToSQL() function that converts a given date into a canonical string that can be fed into raw SQL safely.

And, yes, I agree that if you are not in a US locale, you need to feed your SQL non-ambiguous date values.

I assumed that anyone who is in a non-US locale would have encountered and solved that issue a long time ago, but its certainly worth mentioning for the novice.

I know you are keen on folk trying things out before posting so try this: SELECT FROM MyTable WHERE MyDateTime 1990-01-01 00:00:00.

Perhaps youre not testing in the right context, which in this post is very clearly within Access (read the question again), not using DAO or ADO or ODBC to query data in a JetACE data file.

Did you try it in Access It seems that you quite clearly did not.

See Microsoft Access Report Printing Criteria Selection Form at my website.

This is generally simpler for folks who dont want to get into VBA.

Ive seen lots of Access apps built with this simpler method where the same report layout is saved 8 or 10 times, with the only difference between them being the recordsource.

Of course I expect anyone visiting StackOverflow should know enough to work with VBA a little bit.

Microsoft Access Report Filter