Here is my situation. I have a two tables, one table is Service_Center and one is Semester_Memberships. Semester_Memberships lists each person individually who holds a membership.
I have a form (Service_Center) attached to the Service_Center table and on the form is a text box for Last_Name and a bound Yes/No field for Semester_Towel. When someone clicks the Semester_Towel check box I want a query to run using the last name currently showing in the Service_Center form and look in the Semester_Memberships table for a matching last name.
I know I have to add an expression in the AfterUpdate of the Yes/No field, but I can't get it to work.