On Sat, 27 Dec 2008 16:01:01 -0800, CyndyG
<CyndyG[ at ]discussions.microsoft.com> wrote:
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
[Quoted Text] >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
|