VBA to stop tabbing pass an important field

[fjcunninghamjr]

Hi, Not sure if I am in the right forum, but if someone could help it would be most appreciated!


I have a Field named Operator1, don’t want someone to tab passed this field. I would like to write a VBA code that would not let me pass the Operator1 field unless inputted and offer a message i.e. ‘This field needs to be entered’ Do so now? OK (button).

Frank

[Minty]

The bigger problem is how to ensure they Tab into the field.

If you must have an entry in a particular text box the only place to Guarentee to capture the data being there or not is in the FORMS Before Update event.
There is an excellent article here describing form validation and controlling bad data entry:
https://www.access-programmers.co.uk...ness-1.324342/

[Micron]

Users can mouse click into a field that is "later" in the tab order, so controlling tab key movement is not of much use? If you really had to do this, you'd need to examine whether or not that field has a value for each enter or gotfocus event for every form field after that one.

[Welshgasman]

Make that control the focussed control on form load?
Then validate it before you move to the next control.

[Micron]

Make that control the focussed control on form load?
Then validate it before you move to the next control.

Assume the road block is the 5th field (assuming one can even say that). Request would allow 4 prior fields to be filled in, but nothing from 6 on until 6 is populated. That suggestion would make the 1st 4 incapable of being populated. If that's not an issue, then your idea would probably be the simplest.