Date Picker to feed into qry

[Raddle]

Hi



So I want to create a form displaying top 10 results from a query based on date.

I have the query which count the items, groups them and returns the top 10 WHERE the date has been manually entered by me in the query.

Now I would like to create a form, with a date picker control, and feed that back into the query.

However I have failed at the first, as I can't work out how to create the date picker.

I can't choose the field in the query, because it is not checked to display (otherwise the query tanks).

Any hints gratefully received.

[Welshgasman]

https://www.youtube.com/results?sear...+picker+access

[Raddle]

Ok so there is a Show Date Picker property for the ubound text box that I used .. sorry.

[moke123]

You can always roll your own...