Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 11th, 2005, 08:16 AM
Registered User
 
Join Date: Oct 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Tab Control Selection issues

Hi,
Newbie post here - I've had a good trawl of the internet, but found nothing to answer my particular query:

I have put a tab contol on a form, added three tabs (Say 1,2 and 3).
The form is bound to a linked table. If I select tab 2 then change record, the tab selection automatically jumps back to tab 1. Is there any way to prevent this?
I've tried the programmatical approach of setting a current form flag in the OnChange event of the tab control, but unfortunately this returns the tab to the first one before the record changes.

Thanks in advance, any help would be greatly appreciated,

Justin

 
Old October 16th, 2005, 12:29 AM
Friend of Wrox
 
Join Date: Jul 2005
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It sound like you have code causong this. I have never had this happen unless I have to to cause it.

In the form's on current event, are you moving to a control on the first tab?

Or do you have a navigation button that is moving to a control on the first tab?

Either of these could cause your issue.




Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com
 
Old October 18th, 2005, 03:35 AM
Registered User
 
Join Date: Oct 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You are absolutely right!
Thanks so much for the reply, I was tearing my hair out.:D
I had a function which was updating controls on the first tab which was setting focus on them in my current event. It was an easy job to set the focus back on the previously selected tab after this.

Thanks again for you help,

Justin






Similar Threads
Thread Thread Starter Forum Replies Last Post
How to disable a tab on a tab control. dbradley VB.NET 6 April 14th, 2011 10:04 AM
Calendar Control with Tab Control Slicemahn Access 1 June 12th, 2006 10:35 PM
tab control.. gbianchi ASP.NET 1.0 and 1.1 Basics 0 April 5th, 2006 09:12 AM
tab control p2pMember ASP.NET 1.0 and 1.1 Basics 1 March 9th, 2006 06:39 AM
Tab control Bhanu VS.NET 2002/2003 2 March 6th, 2005 04:12 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.