Calendar 2 part question.

  • Thread starter Thread starter CyndyG
  • Start date Start date
C

CyndyG

I have created a calendar with the days,month and year control,but the
calendar does not allow for multiple date selections. I think I may need to
place a start date and end date on the calendar form,but I am not sure how to
configure them.

Second part of question I have a query behind the form where the status is
set to a closed criteria. would it be possible to use a global on the date
field of the query,so that after the dates are selected the calendar will
close and the actual form will run with the dates from the global appearing
in the date field.

Thanks in advance
 
On Sat, 27 Dec 2008 16:01:01 -0800, CyndyG

More typical would be that your calendar would be used to populate
controls on the main form, so it could be used for all date-related
fields.
Not sure why you are re-inventing the wheel with your own calendar
form.

Yes, you can create a query that "looks back" on a form to pick up
criteria. Something like:
select * from Orders
where OrderDate between Forms!myForm!myStartDate
and Forms!myForm!myEndDate

-Tom.
Microsoft Access MVP
 
Back
Top