On a previous question, since resolved, I asked about selecting records from a table to validate a pay period.
After implementing the suggested solution, I created a message box that would alert the user that the pay period was not valid and asking him/her whether they wanted to continue (a Yes/No button).
If the user selects not to continue, I would like to return control to the date field instead of the next field in the tab order.
I have tried DoCmd.GoToControl, SetFocus methods.
Focus returns to the right field but does not stay there, instead it leaps directly to the next control in the tab order.
I would like focus to remain with the date field so it may be corrected.
Any suggestion?
Thanks
gilles mailhiot