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

 

[vbaInet]

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

Use an IF .... ELSE ... statement to set the Enabled property of the page(s) in concern. I don't think a page on a tab or even the tab control has a Locked property, only Enabled property.

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

The page of a tab has a Visible property.

Here's a link on how to reference correctly:
http://www.mvps.org/access/forms/frm0031.htm

 

[MuskokaMad]

Thanks Again!

 

[vbaInet]

You're welcome!