I have a form with 3 fields, Name, Phone, and Address. I have an Access database with about? 200 entries with the information needed on the form.
The form will not alter the contents of the database.
when I start typing the name in the Name field I need some code to give me a pop up window with suggestions from the database. When I hit Enter, I need the top-most choice from the list to populate the Name field.
Once the Name is entered into the Name field, I need the Phone and Address information to populate automatically from the database.
I also need a function that allows me to add more rows as needed for additional names.