I've got a form connected to a table. Under properties, Data tab, I've set Data Entry to "Yes". This is good because it default the form to a new record when I open it. However, I would also like to have the field in the form that is a primary key to be a drop down menu where I can load existing records into the form for modification.
How do I do that?
How do I do that?