event procedure between a subform and form

[Guest]

I have a form called frm_Vendor (based on a table called Vendor) that has a
subform (based on a table called Application) named subfrm_application on it.
I am trying to set up an event procedure when a field on the subform called
Response_Status is set to "No Reply", it automatically changes a field called
Status_Code on the Vendor form to "Waiting List". How can I do this and
where should I be putting my code? I wasn't sure under which event
procedure or what form's properties I should put it. Here's my guess at the
code which did not work. Thanks!

If Application_Response_Status = "No Reply" Then Vendor_Status_Code =
"Waiting List"

 

[Marshall Barton]

I have a form called frm_Vendor (based on a table called Vendor) that has a
subform (based on a table called Application) named subfrm_application on it.
I am trying to set up an event procedure when a field on the subform called
Response_Status is set to "No Reply", it automatically changes a field called
Status_Code on the Vendor form to "Waiting List". How can I do this and
where should I be putting my code? I wasn't sure under which event
procedure or what form's properties I should put it. Here's my guess at the
code which did not work. Thanks!

If Application_Response_Status = "No Reply" Then Vendor_Status_Code =
"Waiting List"

The code goes in the subform's Response_Status control's
AfterUpdate event procedure:

If Me.Application_Response_Status = "No Reply" _
Then Parent.Vendor_Status_Code = "Waiting List"