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