vba - Why is my .setfocus ignored? -
i have access form textbox meant allow repeatedly typing number, hitting enter, , letting script stuff. speed, field should keep focus after dostuff()
done.
however, while i'm sure dostuff()
run, focus goes next field in tab order. it's me.myfld.setfocus
being ignored.
how keep focus on field after dostuff()
done?
private sub myfld_keydown(keycode integer, shift integer) if keycode = vbkeyreturn dostuff me.myfld.setfocus end if end sub
if @ the order of events keypress change focus, can see follows pattern:
keydown → beforeupdate → afterupdate → exit → lostfocus
you can re-set focus anywhere in there , still keep following pattern. need tell stop following pattern. replace me.myfld.setfocus
docmd.cancelevent
, should fix problem. basically, kicks out of above pattern, exit
, lostfocus
events never fire...
Comments
Post a Comment