Solved

Have tab on a tabbed form remain the focus when move through the records

Posted on 2015-01-19
1
184 Views
Last Modified: 2015-01-19
I have a tabbed form which when opened has the 1st tab being the active tab and this is the way I want it to work.  But also on the form is a combobox that allows the user to navigate through the records.  So if for example the user has the 3rd tab active on the current record and moves to another record, we want the 3rd tab to be the active tab on the record also.  Can this be done?

--Steve
0
Comment
Question by:SteveL13
1 Comment
 
LVL 18

Accepted Solution

by:
SimonAdept earned 500 total points
ID: 40557986
Add something like this to the end of the code behind the combobox

'Assuming you have just requeried or navigated to another record
Me.TabControlName.Pages(3).SetFocus

This will RETURN the focus to the desired tab rather than keep it on the tab, so you may see some flicker.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now