Date Criteria pulled from Calander

[Sharon]

Is there a way to use the dates chosen from a pull down calander for criteria
to run a query?

 

[Conan Kelly]

Sharon,

Where is your pull down calendar? Is it on a form? Is this pull down calendar populating a control on the form?

If so, then Yes, I think so.

Set your criteria to something like this:

# & [forms]![Name of your form]![Name of date control] & #

If you are searching for a range of dates, then you would do something like this:

Between # & [forms]![Name of your form]![Name of StartDate control] & # and # & [forms]![Name of your form]![Name of EndDate
control] & #

I hope this helps,

Conan Kelly

 

[Sharon]

To answer your quetion: This is in a form that has a query to pull "between"
dates.

I tried this by entering the criteria in the query. I get the error that it
is not date format. Any suggestions.

Sharon,

Where is your pull down calendar? Is it on a form? Is this pull down calendar populating a control on the form?

If so, then Yes, I think so.

Set your criteria to something like this:

# & [forms]![Name of your form]![Name of date control] & #

If you are searching for a range of dates, then you would do something like this:

Between # & [forms]![Name of your form]![Name of StartDate control] & # and # & [forms]![Name of your form]![Name of EndDate
control] & #

I hope this helps,

Conan Kelly

Is there a way to use the dates chosen from a pull down calander for criteria
to run a query?