Placing a Report filter at the start-up of a report

[ACMC]

The company I work for has branches in multiple states and we use Access to organize all their tax requirements. We print out reports for every month, and my company would like to create a pop-up window that will let us filter the report when it starts up so that it automatically shows only the dates that we wish it to. How do I create a filter that pops-up when the report starts?

[June7]

I don't recommend popup input prompts. They are difficult if not impossible to validate the input. Have user input criteria into control on a form. Refer to the control as parameter. Options:

1. parameterized query, review: http://datapigtechnologies.com/flash...mtoreport.html
again, not my preferred method, I don't like to set up parameterized query objects.

2. use WHERE CONDITION argument of DoCmd.OpenReport - this is what I usually use - in VBA code something like:
If IsDate(Me.textboxname) Then
DoCmd.OpenReport "report name", , , "[date fieldname]=#" & Me.textboxname & "#"
End If