I have a combo box on a form whose record source is Table 1. The combo box pulls values from an Item table. The field selected in the combo box that I want to store in Table 1 is ItemCalories. However when I add the ItemCalories to a record the ItemID is what gets stored in Table 1, not the ItemCalories even thought ItemCalories is showing in the combo box. I cannot figure out how to get the ItemCalories stored in Table 1. DB attached