Help! Lost Using Calendar Control

[S Jackson]

I am trying to build a form that asks the user for a range of dates so that
the user can print a report for that range.

I put in two ActiveX (?) Calendars. (I'm so lost.) Now what? How do I
tell Access to take the date the user selects from the 1st calendar as the
start date and the date from the 2nd calendar as the end date and then
generate the report?

Is this just much to complicated for an intermediate user?

S. Jackson

 

[Dave Jones]

No it is not too complicated!

If your calendars are named Calendar1 and Calendar2, you
need code like this:

Sub Calendar1_Click()

Startdate= MyCalendar.Value
End Sub

Sub Calendar2_Click()

Enddate= MyCalendar.Value
End Sub

Then just use Startdate and Enddate in the query on which
the report is based.

Dave

 

[Shelly Jackson]

How do I use this in my Query?

Sorry, but I am really green here.

I think I've got set up what you indicated below.

S. Jackson