using calendar control on form in datasheet view

B

BRC

Access 2000, W2k
I have a sub form displays data in datasheet view. Theare are a couple of
date values in each record. I have set these fields to combo box type
control. I would like to use a calendar control on this form to fill or edit
the field values. the mouse down event of the combo boxes will not make the
calendar visible. I can put the calendar on a separate form and open the
form with code or macro. I like the macro method because i use in multiple
places.The question is, how to return the value selected from the macro to
the calling control? I hope this makes sense. Thanks for any advise.
BRC
 
Top