Date Picker Control question

[mattborn]

I want to use Microsoft Date Picker control to make it easier to pick dates. How do I get the date that is picked to become a value in a table?

Thanks

 

[ajdesalvo]

Insert the calendar control on a form, let's name it "Calendar1".

The form's recordsource is your table with the date field, let's call it Date1.

Create a text control box with your date field (Date1) as it's control source.

In the Calendar1's Updated property, select event procedure and go to the code window.

In the top right corner of the window is a list of properties.

Select Click.

In the Click property put:

Me![Date1] = Me![Calendar1]

Good luck!
Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[mattborn]

thanks, works perfectly

 

[markphsd]

Or you can just set the control source of the date picker to be a field from the table. Mark P.

Bleh