forms datepicker help

[gint32]

Hi everyone,


Sounds simple probably to everyone but me!
But can anyone show me an example or even explain on how to requery a form based on a date selected from a datepicker, the form I have at the moment already loads and passes todays date (now() as part of the forms existing querys.

The part I am struggling with is that I can't figure how to change the query to allow for any date selected, whilst keeping the initial it on load to using today date,

So again, what I need have my date-picker add the selected date to the already built query, so as when I select another date it repopulates the form with the new date selected, whilst initially still keeping loading with today's date ,I've tried setting default value to today's date in the text field, but don't know what else i should do.

Many thanks in advance for any suggestions

[isladogs]

I posted an example here using a replacement to the date picker control. Very simple to implement
https://www.access-programmers.co.uk...d.php?t=298062

[moke123]

I'll 2nd Colin's recommendation. Its not only easy to implement, its easy to modify to your liking.

[gint32]

Many thanks for the very useful link, works just fine.

[isladogs]

You're welcome. I use it frequently in almost all my apps