parameter in query

[leangross]

Hi!!!
I have a query that has a paremeter that i use to filter my records. My question is, how can i get the value of the parameter keyed-in by the user and use it in the report or diplay that on the report? Is it possible?

Hope you can help me. thanks!!!

 

[Ziggy1]

If you base your report on the query, the parameter box will pop up when you open the report.

The value in the parameter would already be in the report so it is just a matter of placing it where you want.

Ziggy

 

[Daxton A.]

A parameter query is easy to create. Simply place what text you want the popup to prompt the user saying.

For instance:
If you are needing to get a set of records for a certain date range (say by month)
In the criteria cell, you type:

Between[Enter Start Date]and[Enter End Date]

It's that easy. Just simply put what you want in brackets.
You can even make your own popups with ComboBoxes, Textboxes, Listboxes, etc.
You just use this syntax in your criteria cell. (But Remember...The form must be open already for this to work. So it would be best to run the query from the form itself).
You reference your control object (textbox, combobox, etc.) in the criteria cell by typing
[Forms]![Your Form Name].[Your Control Name]

And that's it. You can also have multiple controls on the form to search by. If you need to know how to make the form open run the query, Email me @ Daxton.Allen@FirstAmericanPlastic.com