TabPages

  • Thread starter Kevin M via AccessMonster.com
  • Start date
K

Kevin M via AccessMonster.com

Hello,

I'm looking for a solution to find the value of the previous tab I clicked,
before the current tab...

Thank you very much for any response !
 
M

Marshall Barton

Kevin said:
I'm looking for a solution to find the value of the previous tab I clicked,
before the current tab...
Click to expand...


There's nothing in Access that provides that information.
You'll have to use a module level variable to keep track of
it using the tab control's Change event and its Value
property.

OTOH, I wonder why you care??
 
G

George Nicholson

One approach:
1) Create 2 variables: mintCurrentPage & mintPreviousPage. These can be
either module/form level or procedure level, depending on how you need to
use them. If procedure level, make sure they are static.

2) During Tab_Change:
mintPreviousPage = mintCurrentPage ' This is where you just came
from (i.e. location after the *Previous* Change event)
mintCurrentPage = Me.tabMain.Value ' This is where you are now.

HTH,
 
P

PC Datasheet

You can determine the tabpage with the expression Me!MyTabCtl.Value. You
need to capture the current page in an integer variable before moving to the
next page. Note that tab pages are 0 based (the first page has a value = 0).
 
Top