Combobox selection to query

[Ray Holtz]

Access 2003 (2000 file format) question:

When I run a form, it opens with only a combo box and a button to
execute a query based on the criteria tha is selected in the combobox.
Then I need Access to open a report using that query.

Can someone give me some pointers on how to do this, or please point me
in the direction I need to look for this answer?

Thanks,
Ray

[Tim Marshall]

Ray Holtz wrote:

Access 2003 (2000 file format) question:

When I run a form, it opens with only a combo box and a button to
execute a query based on the criteria tha is selected in the combobox.
Then I need Access to open a report using that query.

Can someone give me some pointers on how to do this, or please point me
in the direction I need to look for this answer?

Perhaps the easiest way to do this is to first create the query you wish
to have as the recordsource for the report. Use some test criteria.
Set up your report to work as you require.

Next, create the form and the combo box.

Now, go back to the query and open it in design view. Where you have
the criteria beneath a field in the design view, replace it with:

[Forms]![frmName]![cboName]

And save it.

Next you can create a button on your form, and the command button wizard
is helpful here, to open the form.

Voila!
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Ray Holtz]

Hmm, I tried that just now, and after I select from the combobox, and
click the button to open the Report, it brings up a message box for the
query asking to enter a parameter value and says
"Forms!FrmWhichDept!CboWhichDept" and a text box for me to type in. I
am trying to skip this step where it asks the user to type the
department name. This is so the user doesn't have to remember the whole
department name and type it exactly as Access knows it. Rather they
just select it from a combo box.
Thanks, but any other suggestions... anyone?
Tim Marshall wrote:

Ray Holtz wrote:

Access 2003 (2000 file format) question:

When I run a form, it opens with only a combo box and a button to
execute a query based on the criteria tha is selected in the
combobox. Then I need Access to open a report using that query.

Can someone give me some pointers on how to do this, or please point
me in the direction I need to look for this answer?

Perhaps the easiest way to do this is to first create the query you wish
to have as the recordsource for the report. Use some test criteria. Set
up your report to work as you require.

Next, create the form and the combo box.

Now, go back to the query and open it in design view. Where you have
the criteria beneath a field in the design view, replace it with:

[Forms]![frmName]![cboName]

And save it.

Next you can create a button on your form, and the command button wizard
is helpful here, to open the form.

Voila!

[Ray Holtz]

Ok, I had a button calling a macro that first closed the form, then
opened the report, I have it opening the report then close the 1st form
and it works great!
Thanks Tim, you helped me A LOT!
Ray

Tim Marshall wrote:

Ray Holtz wrote:

Access 2003 (2000 file format) question:

When I run a form, it opens with only a combo box and a button to
execute a query based on the criteria tha is selected in the
combobox. Then I need Access to open a report using that query.

Can someone give me some pointers on how to do this, or please point
me in the direction I need to look for this answer?

Perhaps the easiest way to do this is to first create the query you wish
to have as the recordsource for the report. Use some test criteria. Set
up your report to work as you require.

Next, create the form and the combo box.

Now, go back to the query and open it in design view. Where you have
the criteria beneath a field in the design view, replace it with:

[Forms]![frmName]![cboName]

And save it.

Next you can create a button on your form, and the command button wizard
is helpful here, to open the form.

Voila!