Susan Harkins explains how to populate an Access list control instantly by setting properties at the field (table) level to create a lookup field.

Create a Form for a Query or Table, Edit & Delete Data, Navigate through Records, Add & delete Rows and Records in a Form in Access.