I have a textbox on a subform which is a date picker textbox.
On the main form is a back button which takes you back to the previous form.
When you manually enter a date into the date picker textbox on the subform you can click on the back button and it will take you back to the previous form.
If you select a date using the actual date picker in the textbox instead of typing a date in, then you have to click the back button twice to go back to the previous form.
I have tried all sort of events with the textbox, like lost focus, after update etc... and the only one that actually works is the change event, but it changes every single time you enter a digit, which is not what I want to happen, so change works well if they automatically select a date but not if they type a date.
On the main form is a back button which takes you back to the previous form.
When you manually enter a date into the date picker textbox on the subform you can click on the back button and it will take you back to the previous form.
If you select a date using the actual date picker in the textbox instead of typing a date in, then you have to click the back button twice to go back to the previous form.
I have tried all sort of events with the textbox, like lost focus, after update etc... and the only one that actually works is the change event, but it changes every single time you enter a digit, which is not what I want to happen, so change works well if they automatically select a date but not if they type a date.