Insert Date From Calendar

[mercwonder]

I have a form that has a date field. I have a button next to that field that opens another form that I've placed a calendar on. Is there a way to click on a date in the calendar and have it automatically insert the date into the date field on the previous form?

 

[RuralGuy]

Have you tried downloading any of these calendars and see how they do it? Calendar Links

 

[mercwonder]

Thank you very much.. That will work

 

[propolis]

Calendar Control

Hi,

Just used the sample from the link provided.

It sorts of work. The calendar opens, select the date and it appears in the correct field, BUT it doesnt save the date. It keeps on defaulting to todays date.

Any suggestions appreciated

 

[RuralGuy]

It seems to me that link has a half dozen links in it. Which one did you use?

 

[propolis]

Calendar Control

I used the second option.

http://www.datastrat.com/Download/XCalendar2K.zip

 

[RuralGuy]

The sample you pointed to defaults the date of the TextBox to yesterday. Did you do the same? Is your Date control bound to a field in a table?

 

[propolis]

Date is bound to a field in a table

 

[RuralGuy]

Are you changing anything else on the record or just the date? How do you default the date? Can you post your db with any sensitive data removed that demonstrates the problem?

 

[propolis]

Calendar Control

Check the event date field.

Also, when it adds the date, it adds that date for all the records

 

[RuralGuy]

The Event Date control in an unbound control! It has no ControlSource.

 

[propolis]

I thought I had it in there, but hey, looking too long at something makes the mind see things thats not there.

It works fine. Much appreciated for your help

 

[RuralGuy]

A fresh pair of eyes looking at it is always a good thing. Glad I could help.