Form/subform navigation

[Russ]

Access 2007
In my form I've got a subform that is setup as tab stop 3 with one
field. The first tab stops are in the main form. When I press the tab
key after arriving at the subform field the cursor appears to delete
whatever data I had in the subform field and presents me with a blank
space to fill in. How can I stop this behavior and either have my
cursor go back to the main form or "lock out" the tab key?

I thought about changing the cursor behavior when entering each field
from "selecting entire field" to putting the cursor at the beginning
of the field, but being relatively new to Access 2007 I could not find
that option.

Any help would be appreciated.

 

[Russ]

Forget about it. I changed the subform to Continuous instead of
Single. It is not exactly as I think it should function, but I can
get by with it.

 

[John W. Vinson]

There is an alternative: set the form's Cycle property to "Same Record".

Forget about it. I changed the subform to Continuous instead of
Single. It is not exactly as I think it should function, but I can
get by with it.

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Russ]

Much better! I've learned Access with version 2000 and never ran into
that property. Must've come with 2007. I scrolled down that property
list and saw several other unfamiliar properties. Thanks.

 

[David-W-Fenton]

I've learned Access with version 2000 and never ran into
that property. Must've come with 2007.

Nope. It's been a part of Access as long as I've used Access (since
Access 2), and I'd guess it was part of the original release.