Automatically Update Field on Subform?

[batowl]

Hi All,



I am trying to get a field that exists on a subform called Amendment_Number, the field is also called Amendment_Number, to be automatically updated to the text N/A if a database user chooses an agreement type on the main form as Contract. Here is the code I am using.

Private Sub Agreement_Type_Change()
If [Agreement_Type] = "Contract" Then
Amendment_Number SubForm.[Amendment_Number] = "N/A"
End If
End Sub

I cannot understand why this is not working. Any suggestions? Thank you.

[June7]

VBA syntax for referencing subform field is:

Me.subformname!fieldname

Me is alias for main form name and can be used because the code is also behind the main form.

I always give subform container control a name different from the object it holds, like: ctrAmend

Then
Me.ctrAmend!Amendment_Number = "N/A"

[batowl]

Perfect! Thank you!