Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report getting data from parameter query

Status
Not open for further replies.

jlancton

MIS
Jul 26, 2001
82
US
Hi,

I have a small db of help desk calls. I'm trying to generate a report of all calls for a specific person. I created a form that uses a combo box to select the person from the list, but I can't figure out how to get that result to the query as the criteria. I assume I need to have the query pop up the form and somehow read the choice, but I can't figure how to do that. Once that part works it should be just a matter of basing the report on the query.

Any help is greatly appreciated.

Thank you,

-Jeff
 
Hi

Assuming the form will be open whjen the query runs, put Forms!frmYourFormName!cboYourComboName as the criteria in the relavant column of the query in the query builder.

You can get to this via the builder dialog, also
You need to use you form and control name of course Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use
 
Thanks, that and some searching through other threads provided the answer.

Thanks to all. This is a great resource.

-Jeff
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top