move to another control tab programatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I set up a database with control tabs but I'm finding it annoying to stop and
grab the mouse to navigate to the next control tab. I'd like to build a
macro that will programmatically move me to the next control tab but I always
end up with a separate pop-up form.
 
Hi,


Private Sub Command6_Click()
Me.TabCtl0.Value = (Me.TabCtl0.Value + 1) Mod 5
End Sub


would cycle through the 5 "pages" of TabCtl0.



Hoping it may help,
Vanderghast, Access MVP
 
Hi,


Private Sub Command6_Click()
Me.TabCtl0.Value = (Me.TabCtl0.Value + 1) Mod Me.TabCtl0.Pages.Count
End Sub



would be more generic, and not much more complex.

Hoping it may help,
Vanderghast, Access MVP
 
Back
Top