Criteria to give Combo Box for Selection

  • Thread starter Thread starter angela patrikka
  • Start date Start date
A

angela patrikka

Hi
I would like to add a combo box for the criteria on my report. Instead of
the user's having to remember what is in that field, they are presented with
the options at the start. Is this possible?

Thanks
Angela
 
Hi
I would like to add a combo box for the criteria on my report. Instead of
the user's having to remember what is in that field, they are presented with
the options at the start. Is this possible?

Thanks
Angela
Click to expand...

You'll need to use a form to do this.

Let's assume it is a CustomerID number you need as criteria.

Make a new unbound form.
Add a combo box that will show the CustomerID field.
Make sure the Combo Box Bound Column is the
CustomerID field.
Add a command button to the form.
Code the button's Click event:
Me.Visible = False
Name this form "ParamForm"

Code the Report's Record Source Query's CustomerID field criteria
line:
forms!ParamForm!ComboBoxName

Code the Report's Open Event:
DoCmd.OpenForm "ParamForm" , , , , , acDialog

Code the Report's Close event:
DoCmd.Close acForm, "ParamForm"

Run the Report.
The report will open the form.

Find the CustomerID in the combo box.
Click the command button.

The Report will display just those records selected.
When the Report closes it will close the form.
 
Thanks, worked like a charm.

fredg said:
You'll need to use a form to do this.

Let's assume it is a CustomerID number you need as criteria.

Make a new unbound form.
Add a combo box that will show the CustomerID field.
Make sure the Combo Box Bound Column is the
CustomerID field.
Add a command button to the form.
Code the button's Click event:
Me.Visible = False
Name this form "ParamForm"

Code the Report's Record Source Query's CustomerID field criteria
line:
forms!ParamForm!ComboBoxName

Code the Report's Open Event:
DoCmd.OpenForm "ParamForm" , , , , , acDialog

Code the Report's Close event:
DoCmd.Close acForm, "ParamForm"

Run the Report.
The report will open the form.

Find the CustomerID in the combo box.
Click the command button.

The Report will display just those records selected.
When the Report closes it will close the form.
Click to expand...
 
Back
Top