One Calendar For Multiple Date Fields

[Richard_Marx]

I have about 5 date fields that need to be entered on a user form. Rather than have each one be a combo box and it's own calendar, is there a way to have ONE calendar that will display beside each date field?

[RuralGuy]

Are you still using MS Access 2000?

[Richard_Marx]

Are you still using MS Access 2000?

Ah, no. I updated my profile just a few minutes ago. I have moved on to Access 2013

[RuralGuy]

If a bound field is a DateTime field then MS Access can present a calendar for each control.

[Missinglinq]

You can also make this easier on your users, not requiring them to click on the calendar icon, by having the DatePicker appear when the Control has Focus:

Private Sub DateControlName_GotFocus()
   DoCmd.RunCommand acCmdShowDatePicker
End Sub

To have it only do this if the Control is empty:

Private Sub DateControlName_GotFocus()

If Nz(Me.DateControlName,"") = "" Then
  DoCmd.RunCommand acCmdShowDatePicker
End If

End Sub

Linq ;0)>