can someone please tell me which code to type in able to update fields in my form based on what i select in a combo box ?
I have this table with people names, address and phone, and another with their orders. I'd like to select a name in my combo box and after that the other fields in my form (and in my Order table) are automaticaly updated so i can type in the other info in the other fields left in my ordre table (amount, price, date, etc...). I guess i'd have to type in some sort of code in the AfterUpdate event of my combo... is it something like phone = [Orders].phone ?
thanks

Create the combo box using the Wizard and on the first screen select the 3rd item, "Find a record....".