G
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"
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"