Hello, I have a repair business and so far two tables in my Database a CustomerListT, and CustomerPartsT.  The two tables are related.  When I service equipment, I fill in parts FIELDS with parts used for the repair in the CustomerPartsT. I would like to be able to select a customer record from a customer DROP DOWN LIST that I created from a LIST BOX and have the LastName and FirstName record fill in these fields so all I have to fill in is the Parts, Part# and part cost used to repair the equipment. Later I hope to get this information out to a report invoice.   Thank you in advance Horace Conti