Setting properties in a sub-form

lundi 9 mars 2015

I am trying to get the properties of enabled and locked set in a continuious subform depending on a yes/no field in each record. I have tried using the answer in thread 160062, (sorry link is not allowed until I have 10 posts) but this only works when it is not a subform (unless I have done something stupid!)If the main form is frmMain and the continuious subform is frmSub, where am I going wrong with this code which is in the subforms Class Objects?Private Sub Form_Current() If Me.MaterialIssue = True Then CRMSignOffDate.Enabled = True CRMSignOffBy.Enabled = True CRMSignOffDate.Locked = False CRMSignOffBy.Locked = False Else CRMSignOffDate.Enabled = False CRMSignOffBy.Enabled = False CRMSignOffDate.Locked = True CRMSignOffBy.Locked = True End IfEnd Submany thanks for your helpChris

Setting properties in a sub-form

0 commentaires:

Enregistrer un commentaire

Labels