Check this one why cursor move after message to next field of form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

private sub job_gotfocus()
do while isnull(job)
msgbox "value is must here"
exit do
loop
end sub
 
No idea. It works for me. Do you have any other code which might be
switching the focus?

Having said that, I'd be more worried about the fact that one of your more
regular users will be coming to inflict some serious personal injuries
against you in the near future. Probably screaming "I KNOW I MUST PUT A
**** VALUE THERE!!!! THAT'S WHY I PUT THE CURSOR IN THE BOX!!!! DO YOU
HAVE TO TELL ME EVERY ***** TIME?????"

Why not....

a) put a red label by it and a notice saying "Fields marked in red are
compulsory" and
b) check that they have filled it in when moving to another record or
closing the form.

Seriously, your proposed way of doing it would be extremely annoying.
 
Back
Top