How to put input parameters on a form

  • Thread starter Thread starter Darrell Childress
  • Start date Start date
D

Darrell Childress

I have a form that is based on a Select query. The field is ShipDate and
on the query the Criteria is:
Between [Enter Start Date:] And [Enter End Date:]

Is there a way to take what the user types in for "Start Date" and "End
Date" and have them appear on the form somewhere? I want the form to
indicate that the data displayed is from one date to another date.
Thanks,
Darrell
 
add an unbound text box and put it in there...

="dates between: " & [Enter Start Date] & " and " & [Enter End Date]

or similar.

Rick B
 
Hi Rick,
I tried that but it returns #Name?. I checked the spelling and even went
into the query and copied and pasted to ensure I was putting in exactly
the same thing as how the prompt in the query was stated. What I have
done is create 2 unbound text boxes and made one's Control Source
=Min([ShipDate]) and the other Max([ShipDate]). This works for me, but
if the user is requesting data from 8/1/04 through 9/30/04 the form
might display dates of 8/4/04 and 9/25/04 because those are the earliest
and latest ship dates for that customer. The data is accurate (there's
no doubt about that), but I don't want the user thinking that some
information is missing.

Rick said:
add an unbound text box and put it in there...

="dates between: " & [Enter Start Date] & " and " & [Enter End Date]

or similar.

Rick B


I have a form that is based on a Select query. The field is ShipDate and
on the query the Criteria is:
Between [Enter Start Date:] And [Enter End Date:]

Is there a way to take what the user types in for "Start Date" and "End
Date" and have them appear on the form somewhere? I want the form to
indicate that the data displayed is from one date to another date.
Thanks,
Darrell
Click to expand...
Click to expand...
 
Back
Top