In a form, How do I return an Address (on the same form), from a Name picked from a combo box (again on the same form). It's a small invoice database that I wrote for my small business. I made a customer table with names, address, phone number, etc. I have the invoice form, using a combo box, enabling me to pick the name from the Customer table, that is working fine. I can not figure out any way to return the rest of the Address etc. information from that name selection.
Using a List box, I can return all the Addresses, but I need to select just the one record that matches the name that I select from the combo box.