Calendar Control and text box

[cdoyle]

Hi,
I have a form that has 2 Calendar Controls that is used to select a Start Date and an End Date. I then have some code that will enter all the dates inbetween into the database.

One thing I would like to have on the form, is when the users selects a date from each calendar. The date is displayed in a text box under it. Just to have a visual double check to make sure they selected the right month/day/year before they hit the submit button.

Anyone know what code I would need to put in my form to make it do this?

Thanks
Chris.

 

[valheru]

Hi

All you need to do is create a private sub as follows:

( i create a calendar control named Calendar0 and a text box control named Text1 )


Public Sub Calendar0_Click()

Text1.Value = Calendar0.Value

End Sub

Hope this helps

 

[cdoyle]

Ah Perfect!!!
This worked great!!

Thank You!!!