Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / May 2005

Tip: Looking for answers? Try searching our database.

Tabbing out of subforms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jonefer - 02 May 2005 22:19 GMT
Older versions of Access required you to ctrl+Tab out of subforms when
jumping from a subform back to the main form.  

Later versions 2000?  Seem to allow you to do it automatically with a simple
tab.

Is there a setting for this?  I have some subforms that I have disguised as
regular text fields. (By inserting a subform in "single form view" sizing the
form almost as small as the textbox itself, and of course, hiding navigation
etc.)  I'd like the user to tab in and out of these fields unbeknownst that a
subform is being used.... For some reason, it expects a ctrl+tab.

Can I change this setting, or is there a programatic way to mimic this?
Al Camp - 02 May 2005 23:54 GMT
jonefer,
  Try placing one more field (out of site) on your subform with a TabOrder
so that when you hit Tab while in the displayed subform field, you'll Enter
that "dummy" field.  Now the OnEnter event of the dummy field could be used
to navigate to your main form.
hth
Al Camp

> Older versions of Access required you to ctrl+Tab out of subforms when
> jumping from a subform back to the main form.
[quoted text clipped - 14 lines]
>
> Can I change this setting, or is there a programatic way to mimic this?
Dale Fye - 03 May 2005 02:50 GMT
Like Al said, but I'd just use the lost focus event of the contol that
should preceed your "subform" to set the focus to the control on your
subform, then use the lost focus event of the subforms control to set the
focus on the next control in the sequence.

HTH
Dale

> Older versions of Access required you to ctrl+Tab out of subforms when
> jumping from a subform back to the main form.
[quoted text clipped - 14 lines]
>
> Can I change this setting, or is there a programatic way to mimic this?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.