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 / April 2005

Tip: Looking for answers? Try searching our database.

Naming Tabs from Combo Box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve Albert - 29 Apr 2005 21:38 GMT
I have a form with 7 tabs that are labeled "Indicator A", "Indicator B",
"Indicator C", etc. Within each tab, there is a combo box, whose choice I
would like to be the label for the Tab. This would change when the user makes
a choice from the combo box, which is called "Indicator". The text from this
combo box would ideally become the label for the tab, so each tab is called
something more meaningful than "Indicator A", but might be called "Percent
Participation" (which is one of the choices).

Someone suggested using something like this in the combobox's AfterUpdate
event:

 With Me.XXX    'replace XXX with the name of tab control
   .Pages(.Value).Caption = Me.ActiveControl.Value
 End With

It works, though I cannot get the tab name to stay that way when you exit
and then restart the database. It defaults back to Indicator A, etc. I have
tried using Requery in the form or the fields but to no avail.

Any suggestions?

Thanks in advance.

- Steve
Klatuu - 29 Apr 2005 23:00 GMT
That is because the form is not saved when you close it unless you specify
saving it:

DoCmd.Close acForm, "MyForm", acSaveYes

> I have a form with 7 tabs that are labeled "Indicator A", "Indicator B",
> "Indicator C", etc. Within each tab, there is a combo box, whose choice I
[quoted text clipped - 20 lines]
>
> - Steve
 
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.