View Single Post
  #1 (permalink)  
Old May 2nd, 2011, 04:08 AM
sajjad.ansari1982@gmail.c sajjad.ansari1982@gmail.c is offline
Registered User
Join Date: May 2011
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default help required MS Access subform Object control.

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
Reply With Quote