Selecting Date

[Raven]

I have a subform which opens an ActiveXCtlCalendar, it all works fine and I have set the code as follows:

Private Sub Form_Load()

Me.ActiveXCtlCalendar.Value = Date

End Sub

Private Sub ActiveXCtlCalendar_AfterUpdate()

Forms!frmPersonalDetails.ActiveControl = Me.ActiveXCtlCalendar.Value

DoCmd.Close acForm, "frmCalendarPD", acSaveNo

End Sub

This also sets the focus on todays date.

I can select any other date from the calendar, but I can't seem to select todays date which is greyed as the focus is on that date.

Does anyone know how I might over come this problem?

Thanks in advance.

 

[Rich]

Private Sub Form_Load()
Me!SelectDate.Today
End Sub

 

[Raven]

Rich, can you elaborate a little??

Are you implying I add in that code, or replace existing code with that?

 

[Fizzio]

Here is a simple demo on how to use an ActX cal. to populate a field on a form.