Unlocking Fields on a subform

[Dave31]

Hi

I have a subform on a form. All the fields on the form and subform are locked and not enabled.
I have a amend button which should unlock and enable the fields on the form and subform, although, i can unlocked and enable the fields on the form, but cant seem to do it on the subform, the code i use is:

Forms!participantSUBForm2.role.Locked = False
Forms!participantSUBForm2.CDSID.Locked = False
Forms!participantSUBForm2.role.Enabled = True
Forms!participantSUBForm2.CDSID.Enabled = True

Can anyone help?

 

[ansentry]

This is what I use behind a button on my Main form. You have forgotten the bit in bold.

Me.sfrmVehicles.[B]Form[/B].txtVehicleMake.Locked = False

May I suggest that you name the controls different to their Control Source. In my example that is the Name of the Control and the Control Source name is VehicleMake.

 

[Dave31]

Fantastic, thanks and thanks for the tip