Susan has attended:
Access VBA course
Disabling a field in a subform from the main form
I have a form with a subform in it. I can disable the fields in the main form with me.fieldname.enabled = false but I also need to disable all occurences of another field in the subform which could have several occurrences. How do I do this?
Thanks.
Sue
RE: disabling a field in a subform from the main form
Hi Susan
Sorry for the delay in getting back to you, but this was a slightly complex VBA question and we had to wait for one of our advanced VBA trainers to become available to answer the question.
So our trainer Peter has the following code for you.
Function DisableFieldOnSubform()
'Main Form is called Orders
'Sub Form is called - Orders subform
'and field is called unitprice.
'This form arrangement can be found in Northwind.mdb
Forms.Orders.[Orders Subform].Form.UnitPrice.Enabled = False
End Function
Hope this helps
David
