move cursor to specific field on got-focus or lost-focus

[b_c]

anyone familiar w/ the code it would take to move a cursor to a specific field either when the form is clicked or when the form is no longer in "focus"


would that be the correct event to put it in...the "focus" events. i'm fairly new (getting better), so that seems logical to me. the reason i ask, there's also a "load" option, so that would work for me to, but that seems like it wouldn't do the cursor move to field only but when the form is initially loaded.


cheers,


b_c

 

[RuralGuy]

In Access Help, not VBA Help, search for events. You will see all of the events and the order and when they occur.

 

[b_c]

In Access Help, not VBA Help, search for events. You will see all of the events and the order and when they occur.

great, so it looks like if i want the cursor to go to a field in that form after a button is pressed, i would use "lost focus" event...


i'm guessing the code is a docmd code to get the cursor to move?

...i'm looking into that right now. would help if someone could just tell me


can't wait til my two vba books get here next week! i'm good w/ the front end tables/forms/reports...i just need to learn the vba, now.


b_c

 

[b_c]

redid my macro to have a gotocontrol then named the fieldname for the arguement. works like a charm.






b_c

 

[RuralGuy]

There you go. Merry Christmas.