Open form

[Scott Viney]

Hi All,

I have a subform datasheet view. One row holds a date. I have created a
form with only the calendar control on it.

What I want to do is when the user clicks the date, the form with the
calendar is opened and then the date chosen is placed in the date field of
the subform.

How do I do this? I know I have to use the mousedown event. But I dont
know how to get the other form to open and then pass back the value selected
in the calendar.

Any help would be appreciated

Cheers,
Scott V

 

[Wayne Morgan]

For something that works better than the calendar control, I recommend the
following by Stephen Lebans.

http://www.lebans.com/monthcalendar.htm

For the reason to use this over the calendar control, see this link. This
link also has another one to an example of using the calendar control.

http://www.granite.ab.ca/access/calendars.htm