Multiple Calendar Fields with Command Buttons 1

[jimb51]

I have a form with 3 date fields. I'd like to put command buttons next to each field which, when selected, will pop up the ActiveX calendar and fill in the field with the selected date. I can create the command buttons and the calendar form but I'm not sure how to reference that particular date field to the selected date from the calendar. (I'm only using this application in Access 2002 so I'm not concerned about backward or outward compatibility with ActiveX calendar.)
Any ideas?

 

[TheAceMan1]

How are ya jimb51 . . . .

In the [blue]AfterUpdfate[/blue] event of the Calendar Control have you tried:

[blue]Me![purple][b]DateFieldName[/b][/purple] = Me!ActiveCtl[/blue]

See Ya! . . . . . .

 

[jimb51]

TheAceMan1: I'll experiment with that as well. I played around with putting a DateField.SetFocus command following the VBA which opens the Calendar form in Command Button event procedure. That worked as well. I'm always looking for ways to streamline code. Thanks for the quick response!

 

[missinglinq]

Jimb51,

You might also want to simplify your GUI by taking the command buttons off and placing their code in the DoubleClick property of the fields. Works like a charm!

The Missinglinq

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