Check Box is True Assign User ID in Table

[Gus]

Hello,

Thank you for taking the time to help me with my question.

I have a form called CheckOutAgreementRequestForm with a check
box(completed). I want to see if I you can help me create code that will
assign the agreement(Agr_Num) to the User(User_ID) requesting the agreement
in the table tblAgr_Check_Out when the Check box is marked true.

The form is tide to tblAgr_Check_Out_Request containing attributes
(ChkOut_Request_ID "PK",User_ID, Agr_Num, FFIS_Agr_Num, Date_Time_Requested,
Date_Time_Completed, RegUnit,
Completed, NotFound)

One other table is called tblAgr_Check_Out this table has attributes
(ChkO_ID"PK", Date_Checked_Out, User_ID, Agr_Num)

The two tables are sharing a relationship with is tblUsers(User_ID,
User_FName, User_LName) by User_ID.

The table tblAgr_Check_Out_Request is looking up the Agr_Num from the
tblAgr_Check_Out users are able to select the Agr_Num where these agreement
numbers are stored.

Any help would be greatly appreciated.

-Gus