Trap the instance where navigating to end of sub form moves to Main form?

[KC]

Hi, I run Access 2002. I have a multi tabbed main form with a blank
datasheet view subform embedded (for user data entry)
When I use the cursor keys to scroll to the end of the last column in
the subform it focuses on a button on the main form. How do I trap
this event to bring me to the first column in the subform?
I have tried using the on exit and lost focus event on the last column
but it does not work for cursor keys
Any ideas?
Thanks
KC

 

[Guest]

Have you tried setting the cycleproperty of the subform to all records?

Choose properties of the form
Choose cycle -> here you've got three options to choose from. Try one and
find out
(Current page might be an option)

Maurice

 

[KC]

Hi Maurice
I tried this option, does not seem to trap if the cursor or tab key is
used to navigate
KC