I have been trying to figure out this frusterating detail for the last week, and still have not gotten it to work correctly: I have a form, connected to a table, which displays a list of products and corresponding details. The purpost of this form is that it will be used by a user creating an order. I.E. there is an option box (check/uncheck) which allows the user to select the product if it is part of the order. I later run a query to compile all 'selections' and etc-. This is my problem: I need to write some kind of code that will automatically select one product if another is selected. In other words, I know I need some kind of If statement saying "If product A's option = true, then Product C's option = true". I have NO idea how to do this. I know that I will have to insert something in the 'after update' property of the check box, but i do not know what. My main source of frusteration is stemming from my inability to reference what I need to, because it is just one record that I want to be true, not the entire option field for the entire list of products. So, for clarification purposes, say the Primary Key ID for product A is 1, and 2 for Product B. In my head I need some statement saying If(option.1=true) Then (option.2=true) but so far this has not been working. How do I reference specific records of specific tables? I have tried using the expression builder and navigating through the files to get here but that doesn't work either. Any help would be HUGELY appreciated.