calendar pop up to close

[angie]

I have acommand button that has the following on click


Private SubCommand213_Click()
Me.ServiceDate.Value= ""
Me.Employees.Value= ""
DoCmd.Requery
End Sub

The servicedatefield has a date picker with the follow two events.

Private SubServiceDate_Change()
DoCmd.Requery
End sub

Private SubServiceDate_GotFocus()
RunCommandacCmdShowDatePicker
End Sub

When I clickthe command button it will clear the date from the servicedate but the datepicker calendar will pop up to choose a date. I would like the calendar not to open when this command is clicked.

Thanks Angie

[June7]

Tried to replicate issue and can't. As soon as I go to click the button the DatePicker closes. However, have to click twice to activate the button if focus is on the DatePicker popup.

Why do you need to Requery just for a data edit?

[angie]

I have a combo box that filters the form by employee name. so I have to close the date picker so I can choose employee,

[June7]

I usually find the date picker more annoying than helpful. I set up textboxes for date entry with an input mask (99/99/"20"00;0) and the date picker does not activate.