set focus

T

tkaplan

I have a form with a txt box named txtAuditor. on the exit event, i have
some validation checks.
i want that if the validation fails, the focus will go back to that txt
box.

i currectly have

if variable=false then
txtauditor.value=""
txtauditor.setfocus
endif

this did not work!
Any suggestions??
 
D

Dave O

Sure looks like it should work. One debugging strategy is to put a
Msgbox statement inside your "if variable=false then" / end if
statement. That way you can deliberately cause your validation to fail
and when you get the message box you know your logic is sound.
if variable=false then
Click to expand...
msgbox ("About to set focus to txt.auditor")
 
T

tkaplan

it does enter the procedure- it also resets the text box

I think what is happening is that it is still letting the user exit th
txtbox so it sets the focus, but then the user exited. i set cancel t
true and then is worked:
 
D

Dave O

....Or, now that I hearken back to my Access programming days, try this:

if variable=false then
me.txtauditor.value=""
me.txtauditor.setfocus
endif
 
Top