Link to home
Start Free TrialLog in
Avatar of scottdfreer
scottdfreer

asked on

How do I write a simple invoice database in MS Access 2003?

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.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial