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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KC - 25 Apr 2007 17:22 GMT

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

Reply to this Message

Maurice - 25 Apr 2007 20:14 GMT

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

> Hi, I run Access 2002. I have a multi tabbed main form with a blank
> datasheet view subform embedded (for user data entry)
[quoted text clipped - 6 lines]
> Thanks
> KC

Reply to this Message

KC - 26 Apr 2007 16:23 GMT

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

Reply to this Message