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

K

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
 
G

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
 
K

KC

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update subform with combobox change on main form 1
Tabbing between a main form and a subform 1
Main \ Sub Form Data 1
How to make a sum of a sub-form on the main form 2
copy field from main form to sub form 8
Main form sum from sub form 0
Trouble Filtering a Sub Form With Combo Box Options 2
If subform dirty, field in main form visible 2

Top