pop up calendar on a report

P

PattiP

I have a report based off of a select query that asks to enter the start and
end dates. Is there a way to have a pop up calendar appear rather than the
dialog boxes so the end user can just click on the start and end date?
 
C

Crystal

Patti,

If you want to use the controls on a form for your query
parameters...

formname: ReportMenu

make two textboxes:
NAME of beginning date control --> Date1
NAME of ending date control --> Date2

criteria in your query under the date:

criteria --> between cDate(forms!ReportMenu!Date1) and
cDate(forms!ReportMenu!Date2)

I used the cDate function since unbound TEXTboxes on forms
think everything is a string

Warm Regards,
Crystal
 
Top