[AccessD] Tab control click event

Come to think of it Doug, I did something like that on a tab form where I
disappeared the tab and replaced it with a label, which looks nicer, you can
format it, and has a Click event where you can do whatever and then set the
focus to that page:

    Me.TabCtl140.Pages(1).SetFocus

HTH

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Monday, April 25, 2011 1:54 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Tab control click event

Darrell,

Why not use buttons to control the tab change and put the refresh code in
the button on-click before you change the tab pages?

Doug

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darrell Burns
Sent: Monday, April 25, 2011 10:18 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Tab control click event

Howdy. I have a form with a tab control and multiple pages. I have to
refresh the table bound to each page as it's clicked. I can do it with the
Change event but then you see the table being deleted and refreshed and it
looks clunky. What I'd like to do is capture the click or mouse-down event
as the user selects a tab so I can do the refresh before the page changes.
But none of seem to work. I've put a debug on both the click and mouse-down
on the tab control, and on each page control, and I get nothing. Is there
some other way of trapping the tab click before it changes?
Thx, DB

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com