updating subform

[cgrinage]

I have a form with three subforms (Request, Employee Availability, and Employee Assign) in the image below. The user enters the ID in the Assign form (#4) which relates to the request at the top. When the user moves to the next record I want the value of the "Assigned" field at the top to be updated to "yes" for the record with the same ID as enter below. In the end the following item with disappear when you return to the record: ID #4, Employee ID 109187, and Request ID 2 from the below form.

My problem is I not sure how to get the Request form to update after the user moves to the next record. Any help would be appreciated. Thanks!

[June7]

Possibly run an UPDATE sql action and requery the Request subform.

Personally, I would not save the Yes/No value to table but determine this status by query joining tables and an expression in textbox.