Textbox calendar - date picker - event to close after date made

[Rx_]

User Interface question:

A Textbox for a Date with the date picker enabled is a required field on a form.
When a new record is created, the user can click on the textbox, choose a date from the calender date picker.
The date fills in the textbox. But, the date picker stays visible.
Problem: None of the events (change, update...) on the textbox with the date execute. In debug mode, the textbox still shows a value of null.

If the user Tabs from the Date Submitted, no problem, the calender datepicker goes away, the textbox updates and vba code can move the focus to the next control, sets the blnEditMode to False and more.

If the user picks a date with the mouse, the date picker remains visible and without vba validating there is a date entered... the user can not click on the next textbox. All textbox are disabled until the required date is validated. That is, until the calendar control is completed... the validation events can not take place.

 

[Rx_]

Guess I found what causes this... but still don't have a good solution.
My Add New button creates a new record.
The Date Submitted is enabled - a vba loop disables all other controls.
If the Date Submitted receives a value - and the user clicks the Tab - this forces the events for Date Submitted to fire. Within those events is re-enabling other controls and moving the focus the the next control (named State).

So, the user wants to use the mouse to update Date Submitted and move the mouse to the next control. Problem, the next control is not enabled. And, without a change in focus, the date picker stays enabled - and doesn't fire any events. Even the Mouse UP event is ignored.