I have a new problem I have a Form with three tabs. I want the third tab to open auto when a text box on the first tabbed subform is updated. I have tried the SetFocus event but this will not work, as the subform is not already open. In conjunction with this I have a Select Case statement that auto selects a form to fill this subform I just want the this subform to open if one of the select case form is selected in stead of having click on the tab.
3  1640 
I have split this post off from the 3 month old, unrelated thread you posted it in! In the future please start a new thread when you have a new problem/question.
You also never bothered to respond to my post on your previous thread nor give any indication as to whether you had resolved you problem. Forum etiquette, here and elsewhere, requires that you acknowledge responses to your threads and post how you resolved your problem, even if you did so on your own, so that other visitors to your thread may be enlightened.
Linq ;0)>
Moderator
That was rude of me and I do not use this much to post just to read. Lots of info to be had.
However, if possible I would still like some help with my problem. I
I have a new problem I have a Form with three tabs. I want the third tab to open auto when a text box on the first tabbed subform is updated. I have tried the SetFocus event but this will not work, as the subform is not already open. In conjunction with this I have a Select Case statement that auto selects a form to fill this subform I just want the this subform to open if one of the select case form is selected in stead of having click on the tab.
I don't know about your tabbed subform not being open. I think you can just use this to have the third tab come into focus: - Private Sub txt1_AfterUpdate()
-
-
Forms.Mainform.TabCtl = 2
-
'other code
-
-
End If
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Steve Miles |
last post by:
I've got a tabbed form with the 2nd tab containing a subform. I'm
trying to avoid the need to use the mouse to set focus to the first
field on the subform. I can use <CTRL><TAB> to open the 2nd tab, but
I can't get the first field to receive focus until I click in it.
Here's what I've already tried/checked:
1) I've commented out the "On Current" event VB code.
2) The first field IS a tab stop and it's first on the tab order.
|
by: Brian Keanie |
last post by:
Is it possible to set different colours to each tab in a tabbed subform?
|
by: swingingming |
last post by:
Hi, in the NorthWind sample database, when clicking on the next
navigation button on the new order record with nothing on the subform
(order details), we got an order with nothing ordered. How can we
prevent this from happening?
Thanks.
ming
|
by: Mary |
last post by:
I have a tabbed form. Tab 1 has fields that are mandatory. I am trying
to validate that these fields are not null, and cancel updating if any
of them are. The following code works, except the form closes instead
of setting focus to the null field. What am I doing wrong? Do I need to
refer to the tab name when I set focus? I sure would appreciate any
help!
Here is my code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
|
by: kev |
last post by:
Hello,
I posted a question a while ago on tabbed pages, how to set it to
invisible when the text box is empty.It was answered by Rick and the
code ran perfectly. However, i tried using the same code for another
scenario and it gives me compile error:method or data member not found.
My scenario is i have a nested tab page.My main tabbed page has 4 tabs,
About, SafetyLevel1,SafetyLevel2,SafetyLevel3. Inside this main, i
created a...
| | |
by: NeoPa |
last post by:
Originally posted by Missinglinq:
The first thing to remember is that Tabbed Pages are all part of a single form; think of it as a really long form turned on its side and folded on itself. Because it is all one form, references to contols on any page are done in the same manner as if they were all on one single screen.
Create a form in Design View. Goto the toolbox and click on the Tabbed Control icon; it actually looks like several...
|
by: AndyM |
last post by:
Hi,
I have a curious problem that is causing me large amounts of grief and is steadily turning me grey. Hopefully you guys can help.
I have a Master table that contains a CustomerID (as well as customer name etc), this is used as the Primary key to all the tables relating to that customer. I've been using 1 to Many relationships for most of the tables (e.g A customer can have many addresses) with Referential Integrity and cascading turned...
|
by: Henry Stockbridge |
last post by:
Hi,
I have a main form (bio info) with a tab control containing three
pages (employment, financial and dependent, respectively.) When I
move record to record on the main form, the correct information is
displayed on the tabbed subform. However, when I go to, say, the
fourth record on the main form, and click a different page on the tab
control, the main form record reverts back to the first record.
Any help you can lend would be...
|
by: c0l0nelFlagg |
last post by:
I have a moving dispatcher database. There are 99 drivers, 99 loaders,
and 50 different vehicles. The scheduler database is built on a 13
4 week month year so that it can be used repeatedly in any subsequent
year and recalculate the dates so that each year it is referenced to
the first available business day of any given week. This is done by
running an update query that calculates the date based on a formula
related to the month week and...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
