Access 2000 VBA - TechRepublic
General discussion
March 7, 2001 at 08:36 AM
gemailhiot

Access 2000 VBA

by gemailhiot . Updated 25 years, 3 months ago

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

This discussion is locked

All Comments