how to get a pop up calendar on a date field

[accessmatt]

Hello, I have a date field in my table which is set to show date picker for dates. I would think that means that the little calendar would pop up when I select into that field, however it does not. I'm trying to put this date field on a form. Does anyone know what I can do to get that calendar to pop up where a user can select the date?

thanks!

[Missinglinq]

This bit of code will make it pop up:

Private Sub YourDateField_GotFocus()
  DoCmd.RunCommand acCmdShowDatePicker
End Sub

Replacing YourDateFieldwith the actual name of your Control.

Linq ;0)>

[accessmatt]

Thanks Linq but I'm getting a 2046 error on that. Any ideas?

[June7]

The control must be bound to a date/time type field or set the Format property to Short Date.