Calendar Control

[Ima Lostsoul]

I cant seem to set the date on the calendar control. What i want to
happen is have a form pop up when a button is clicked (have that part of
course). This for has a calendar control on it. I have the code to
pass the date selected back to the original form working just fine. I
want to have the calendar start with whatever the current date is as the
selected date -or- a specificed date passed to the form (by a global
variable) based on a condition. I know how to test the condition with
an IF loop. I just can't seem to set the date on the calandar control
when the form opens. Any help please?

[David Neagle]

Ima Lostsoul <[e-mail]> wrote in message news:<MP************************@netnews.comcast.n et>...

I cant seem to set the date on the calendar control. What i want to
happen is have a form pop up when a button is clicked (have that part of
course). This for has a calendar control on it. I have the code to
pass the date selected back to the original form working just fine. I
want to have the calendar start with whatever the current date is as the
selected date -or- a specificed date passed to the form (by a global
variable) based on a condition. I know how to test the condition with
an IF loop. I just can't seem to set the date on the calandar control
when the form opens. Any help please?

In the On Open event of your calendar control put this code.

Private Sub SelectDate_Open(Cancel As Integer)
Forms!frmYourFormName!CalendarControlName.Value = Date
End Sub

This will open the calendar control with the current date. I think you
will find that the calendar control does not have its own open event
procedure, so Just type the code in.

David

[Ima Lostsoul]

In article <MP************************@netnews.comcast.net> ,
[e-mail] says...

I cant seem to set the date on the calendar control. What i want to
happen is have a form pop up when a button is clicked (have that part of
course). This for has a calendar control on it. I have the code to
pass the date selected back to the original form working just fine. I
want to have the calendar start with whatever the current date is as the
selected date -or- a specificed date passed to the form (by a global
variable) based on a condition. I know how to test the condition with
an IF loop. I just can't seem to set the date on the calandar control
when the form opens. Any help please?

Never mind. I was being stupid...