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

Popular posts from this blog

c# - How Configure Devart dotConnect for SQLite Code First? -

java - Copying object fields -

c++ - Clear the memory after returning a vector in a function -