@ray: "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"
    @TIMMY: "<quote>
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    <url>
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto  "TIM-MAY!!" - Me"
    @ray: "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?
<quote>"
{'source': 'USENET', 'other_information': '{"reply_count": 2, "forum_name": "comp.databases.ms-access.20140812.mbox"}', 'file': 'data/output/usenet-comp.databases.parquet'}