Parameter input box

[joand]

I have the report and query set up and it's working fine. What I want to do is modified the information shown on the inputbox so the user will understand what data I'm asking them for.

The criteria listed in the query is what shows in the Enter Parameter Value box which is:

Forms!frmproj!ID

Not too descriptive from a user point of view. How do I change that?

 

[David R]

You can make your parameter as descriptive as you want. Try
Criteria: [Please enter the ID for the person you want:]

Ok, so maybe Access has length limits on parameters, but you get the idea. Just keep in mind you have to refer to it by exactly that name every time you use the value...

HTH,
David R

 

[joand]

Thank you David. For some reason I thought I was giving the query the selection criteria in that area...not what should go on the input box.

 

[David R]

You can combine it with other bits of criteria, like:
Criteria: Between [Enter start date] And [Enter End Date]
for a report.

But if you enter it by itself, it uses it as an exact match. Visualize it as a really large, descriptive variable.

HTH,
David R