This is my first question post so sorry if not everything is clear, I am still getting the hunk of it. I am a very novice beginner willing to learn ^_^
I am trying to set up an order form for purchase of optionally more than one product that each have different customization options based on their category they belong to. The main form contains details about order number, customer, destination and in a subform a continuous form for adding the different products.
So far, I made (in the subform) a combo box that autofill based on choice the standard fields that is for every product. I added a tab control with different pages for each category of product that includes the fields for the different options. I am trying to set up a trigger event to change the visibility of the pages based on the category that gets autofill from the combo box choice when a product is chosen. My attempt:
VBA set an on Current event on the sub(continuous)form
I am getting an Error message when I try to reopen the form
I am trying to set up an order form for purchase of optionally more than one product that each have different customization options based on their category they belong to. The main form contains details about order number, customer, destination and in a subform a continuous form for adding the different products.
So far, I made (in the subform) a combo box that autofill based on choice the standard fields that is for every product. I added a tab control with different pages for each category of product that includes the fields for the different options. I am trying to set up a trigger event to change the visibility of the pages based on the category that gets autofill from the combo box choice when a product is chosen. My attempt:
VBA set an on Current event on the sub(continuous)form
Code:
if me.category.value = Chair then
Me.tabctrlproductoptions.Pages(Chair).visible =True else
Me.tabctrlproductoptions.Pages(Chair).visible = False
end if
I am getting an Error message when I try to reopen the form