Combo box to update table in a form

[TG_W]

Ok. I'm stuck. Here is what I am working with:



A form whose data set is coming from a query (in the form) on 2 tables.
A combo box where I select a record from one of the above tables.

Where I want to go from there:

When I choose the record, I want to make True a boolean record in the other table. After the record is set true, I want to requery the tables (which I already know is - Me.Requery)

The main link between the two tables is an ID number that is a primary key.

Thank you in advance for your assitance.

[TG_W]

Ok. I have my original problem solved. I dropped the table that needs to have the check box checked, and I am filtering the ID numbers I need by the transaction number. Hooray!

Now I have a new problem. I need to be able to not update some of the records based on the ID numbers as multiple IDs can be included in one transaction. For example:
Transaction 2100 included IDs 1, 2 and 3. I updated the data originally using a different form. Now, I want to update IDs 1 and 3 only, but my filter when transaction 2100 is selected brings up IDs 1, 2 and 3.
I added a check box to the form and have started to write an If..Else VBA statement. I have the code written to update the table, but what should I write to skip a record when the box is unchecked.
FYI, I have the default for the check box set as "= True", as it is a more likely I will be updating all of the records, but the number of records can get pretty high, so it is easier to remove than add.
I hope that wasn't too confusing. Thank you for any help.