Access 2002 How to "Send Keys" in macro

[Louise99]

I would like my form to do a "Ctrl-Home" after exiting the last field (so it will show the entire beginning of the form). I have the send keys in my macro for the last field but I can't figure out what to put in there! Someone "borrowed" my Access book so I really need your help!

Thanks,
Kat

 

[fneily]

I'm assuming that after it exits the last field it starts a new record and that's what you want to stop. Go to design view of your form, click the little square in the top left corner - when you do, a black square will appear - bring up the property sheet for the form and scroll down to the option CYCLE. Change it to Current Record. Now when the user leaves the last field, it'll go back to the top.

Please ask all Access questions in the Access forums. You will get more responses.