Solved

How to detect change of tab control page

Posted on 2009-04-14
7
193 Views
Last Modified: 2013-11-26
Access 2003

I have a two-page tab control with subforms on each page. I need to run code when the user selects a tab page. The tab page On Click event fires when the body of the tab page is clicked, but I can't get it to fire when the tab name is clicked. I've also tested this with a blank tab control on a blank form, with the same result. So how do I run code at the point the user selects the page?
0
Comment
Question by:SteveCond
  • 4
  • 3
7 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 24136640
just to confirm, is this form developed using visual studio or msaccess?
0
 

Author Comment

by:SteveCond
ID: 24136660
Beg pardon - brain not in gear yet after the Bank Holiday! I meant to put it just in the msaccess area. I also accidentally gave it 500 points - but I'll let it go at that (Happy Easter.....)
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 24136668
Trust you had a good Easter, nice long weekend :)

Try using the On change method instead
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:SteveCond
ID: 24136746
Wonderful time thanks - but too much booze! Yourself?

On change works a treat. Thanks!
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 24136767
Booze just the last two days unfortunately, Ive had this damn cough I couldnt get rid of so ruined it a bit, otherwise was good. And of course good footy at the weekend.

Glad you got it going
0
 

Author Closing Comment

by:SteveCond
ID: 31569833
Shame about the cough!
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 24136965
thanks buddy, good luck with the rest of your project
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

792 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