i want to Enable or disabled form object(fields) depending on other fields value.
i.e m developing invoice software in MS Acess. and i want to disabled/enabled subform fields Invoice_Selection baseed on other field (Status) depending on two values
1= Order Placed
2 = Invoiced.
and an option field Name = Invoice_Selection.
so my question is, in a subform where (status) = Invoiced ,Invoice_Selection Fields object disabled. "only those where status = Invoiced" remaining will be enabled. (VBA Coding required)
m waiting for ur Response