Date Field in a Search Form with a date picker option

[oblivion86]

Hi,

How do I go about implementing a date field with a date picker option in a search form?

I can only manage to get the date picker option if i create a form directly from a table where the date field is in the date/time format.

I am unable to create a search form from scratch and have a date picker option for keying in the date and then running a query from the search form.

Thanks in advance!

 

[vbaInet]

If you set the Format property of the textbox to a date format, the Date picker will become visible.

 

[oblivion86]

Hi thanks for your reply, I managed to solve the issue by just clicking the "add existing fields" tab at the top right.

This way, the field in the form will be in the same format as the one in my database.

 

[vbaInet]

I hope you removed what's in the Control Source?