Ok, I have a form with a tab control object on it containing 3 tabs/pages...Anyway, I also have two buttons at the bottom. One is a back button and the other is a next button. Simple enough I just want these buttons to go through the tabs. I can do it in visual basic but not VBA. What is the VBA answer to tablcontrol1.selecttab = "tab1"? can anyone help with this?

Hi,

   You can use the tab order dialog. In form design, right click on the form and select tab order.

   If you want to do this programatically, you need to choose the event that triggers the change in focus (even if it is the form's on open event) and use this code:

Forms!MyForm!MyControl.SetFocus

HTH

mmcdonal