For some reason, I have struggling with using a form with a combo box. I have two tables, FamilyT and FamilyAuditT. I want to use the FamilyAuditT to record a select family for the Audit and the Audit Date. The Form Record Source is FamilyAuditT. The Combo box selects a family name from the FamilyT and records the value in the FamilyAuditT. It is working except that the FamilyName in the FamilyAuditT displays the Famity ID and not their text. I need to seem the family name and not thier ID values for my query. What am I doing wrong?