Enabling a control and moving to a new tab in vba

[MuskokaMad]

Thanks for your assistance.

I have a parent form frm_NewOrderEntry with 3 Subforms on tabs.

I would like to enable each tab after the user confirms they have completed filling the information.

I assume I will set the Locked Property to True for the tab controls when the form opens.
I would then put a button on the subform that uses code in the ONClick Event like.

tabPayments.Locked=False
tabOrders.Locked=True



Is this correct and how do I close the current tab in the above case tabOrders and open the tabPayments tab???

Thanks Jason

[MuskokaMad]

Worked out a solution. Thanks again.

Used :

Private Sub cmdMakePayment_Click()
Forms!frm_NewOrderEntry2!tabPayments.Enabled = True
Forms!frm_NewOrderEntry2!tabPayments.SetFocus
Forms!frm_NewOrderEntry2!tabOrderDetails.Enabled = False
End Sub