I have a main table that contains several text fields where the Display Controls are combo boxes. The selection choices for the combo boxes are from a second table. This main table is the record source for a form. As shown in the image below, when P5 is selected per the drop down, I would like P5Price and P5Description to auto populate with their corresponding values from the second table. I can accomplish this with DLookUp’s as seen in the example, but I need the results stored in the main table for the unique record that is being viewed in the form. Thanks in advance! GM