I have a date field on a subform and unless you manually click a different control after selecting a date then I have to click the button on my main form twice.
I have tried everything I can think of, tried setting focus to the button after update, after change etc..., tried dirty=false, but unless you click a different control you must click the button on the main form twice.
The setfocus to the button seems to work yet when you click the button on the main form the focus goes back to the date control
even If I just put a code in the commandbutton like msgbox "Yes", the msgbox does not display unless you click the button twice.
I have tried everything I can think of, tried setting focus to the button after update, after change etc..., tried dirty=false, but unless you click a different control you must click the button on the main form twice.
The setfocus to the button seems to work yet when you click the button on the main form the focus goes back to the date control
even If I just put a code in the commandbutton like msgbox "Yes", the msgbox does not display unless you click the button twice.
Have to click button twice