CALENDAR CONTROLS

[netrusher]

I am currently using a popup Calendar in Access "Calendar Control 9". I mousedown on a field and the Calendar pops-up. I select the date and it populates field1. So far, so good. After I select the date I need I would like for field2 to populate with a date that is exactly six months out from the date I selected for field1. Any suggestions.
I hope this can be done as it would help immensely.

 

[ZmrAbdulla]

Search for "DateAdd" function in the help file

________________________________________
Zameer Abdulla
Visit Me
A child may not be able to lift too much.
But it can certainly hold a marriage together

 

[missinglinq]

Substitute the name of your "filed2" for my "NextVisit", then the name of your Calendar for my CalCalendar and it should work! Works for me!

[NextVisit] = DateAdd("m", [6], CalcCalendar.Value)

Hope this helps!

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[TheAceMan1]

How are ya netrusher . . . . .

You have to decide what you want to do about the following ambiguities:
[ol][li]Day of date is 31 and +6 months is a 30 day month.[/li]
[li]Date is Aug 30 or 31: +6 months is Feb.[/li][/ol]

See Ya! . . . . . .