Date Picker for Select Parameters when running query

[Appollobsg75]

I have an access database and in it I have a few queries that run on a date field. They have the date range =between [start date] and [end date]. so when I run the query it pops up with me to enter in that information. Is there a way to enter a date picker on that select parameter window? Or do I need to create something else to allow for a date picker?

[Minty]

Short answer is No.

You should build a form with two unbound controls txtDateFrom and txtDateTo. Format them to short date. Then the date-picker will appear when you are in those controls.
You can then refer to those in your query instead of your parameters.

[davegri]

CAHS Hour Tracker - Craig-davegri-v01.zip

AS Minty suggests: Add a popup form to enter the dates


Then modify the Edit Hours form's recordsoure query:

[Appollobsg75]

Thank you Minty and davegri, it works out fine. I will use it that way with a form to use for my start date and end date, instead of the parameters I was using before. I appreciate the help. May the Force be with you.