Calendar

T

tiredoftrying

Using the Standard Calendar control on a form I want to be able to click on a
dat and it populate that date in a text box also on the form
 
M

Mystrye

First in design view on the form, click on the calendar, view properties.
Click on the grey area to the right of the property (on updated). Click on
the 2 dots and choose Code Builder. When the code window opens. Type
Me.(whatever the name of the field you want the date value in) = Me.(name of
Calendar).Value

( Me.fieldname = Me.cal0.value )
Name of field Name of calendar
Then save and close. That should work. I do that all the time.

Sorry If I went into too much detail, but I'm not sure how much you know.

Penny

Hope this helps.
 
F

Fred

Helps me too - thanks!

Fred


First in design view on the form, click on the calendar, view properties.
Click on the grey area to the right of the property (on updated). Click on
the 2 dots and choose Code Builder. When the code window opens. Type
Me.(whatever the name of the field you want the date value in) = Me.(name of
Calendar).Value

( Me.fieldname = Me.cal0.value )
Name of field Name of calendar
Then save and close. That should work. I do that all the time.

Sorry If I went into too much detail, but I'm not sure how much you know.

Penny

Hope this helps.
Click to expand...
 
T

tiredoftrying

wonder why the on update will not update the textbox, but I can create a
command button with the same code and it will - its like the on update is not
working
 
D

Dorothy

I was wrong before, I tried the code, but to get the date to populate the
field, after you choose one from the calendar, the calendar also has to stay
on the form, to refer too.
 
Top