[AccessD] Tab control click event

Are you doing refresh or requery?

If the refresh is because of a change on the previous page, can you refresh
the data in the after update event of the control on the previous  page that
causes a change in the other pages?  Then when the tab is clicked the data
will already be refreshed.

Or would that cause too much delay?

Rocky


-----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