Display Parameter Criteria on a Form

bill crumpton

Registered User.
Local time
Today, 06:01
Joined
Apr 20, 2000
Messages
105
I know that a query parameter criteria can be displayed on a report, (i.e. Date range "from" "to")but can this same type of information be diaplayed on a forms unbound field? I tried it and it didn't work. Thanks for any help.
 
Exactly what is the problem? Usually you would use a form to enter the query parameters. Otherwise, where would you be getting the parameters to display?
 
I am getting the parameter value from the criteria in a query. Under the date field on a query in the criteria I have "Between [Enter Beginning Date] And [Enter Ending Date]". I would like to show those two dates in two unbound fields on a form. Thanks for your help.
 
Why don't you have your user input the parameters on the form rather than the query? Just set the criteria of the query to say:
Between forms!yourform!begin and forms!yourform!end

That way the user is not prompted twice.
 
Thanks Neal, I did change it to input the criteria from the form. I was just curious if there was a way to show the parameter query in a from. Thanks for your response.
 

Users who are viewing this thread

Back
Top Bottom