I am building a simple Order form with OrderDetails subform. I need all the controls on the main form (CustomerName, OrderDate etc) and on the subform (Quantity, Listprice etc) to become locked (changes disabled) once I select Closed status in the OrderStatus combobox of the main Order form (only OrderStatus combobox should remain active in case I decide to update the order anyway).
I guess it has something to do with AfterUpdate event of the OrderStatus combobox and Current event Me.AllowEdits = False of both forms.
My VBA (un)knowledge does not allow me to make it properly.
I would appreciate experts' help.
I guess it has something to do with AfterUpdate event of the OrderStatus combobox and Current event Me.AllowEdits = False of both forms.
My VBA (un)knowledge does not allow me to make it properly.
I would appreciate experts' help.