drop down and date range for report criteria

[rkroegerjr]

I have an account activity report that I want to set up as follows. I
want to have a drop down box that has a list of account names where I
can select one name and get a report on that account. I want to
further restrict the report to only display activity during a selected
date range. Currently I can get the report to do only one or the other
but not both at the same time. Any help? Thanks.

 

[Jeff Boyce]

One approach to doing this would be to create a form and add a combo box for
selecting account names and a pair of date fields for a date range.

Then modify the query that feeds the report to use the form's values as
selection criteria. In the query, the criteria would look something like:

Forms!YourNewForm!cboYourAccountComboBox

Note that you HAVE to have the form open, and values selected/entered for
this approach to work.

You would add a command button on the new form that opens the report that is
based on the query that uses the controls on that form to provide the
selection criteria.

?!confused yet?! <g>

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[rkroegerjr]

Jeff-
I creatted an unbound form with a combo box with the account names and
two text boxes one for a beginning date and the other for an ending
date.

I added a Command Button pointing to the report I want.

I added the criteria to the query Forms! "The Form Name"!cbo "ComboBox
Name"ComboBox

When I select the Account name I want a report on, fill in the start
date and end date and press the command button I get back a pop up that
requests I enter a parameter value. Filling this out does nothing.

Confused? You betcha!

I appreciate any help you offer

-Russ

 

[Jeff Boyce]

Russ

Can you confirm that the AccountName you are selecting works in the query
directly? Usually, getting a prompt means something's mis-spelled.

Regards

Jeff Boyce
Microsoft Office/Access MVP