Hi Jonathan,
assuming that city and state is stored with your customer #
in a table (I have called Tablename), you can do this:
combobox:
Name --> CustNum
ControlSource --> CustNum
RowSource -->
SELECT CustNum, Customer, City, State
FROM Tablename
ORDER BY Customer
ColumnCount --> 4
ColumnWidhts --> 0;2;1;1
Listwidth --> 4
once you pick a customer, you can echo values from the other
columns in calculated controls
textboxes:
Name --> City
ControlSource --> =CustNum.Column(2)
Name --> State
ControlSource --> =CustNum.Column(3)
column indexes start with 0 so column 2 is really the third
column of your combo
you will have to substitute the appropriate fieldnames where
I have used CustNum, Customer, City, and State
Warm Regards,
Crystal
Microsoft Access MVP 2006
*
Have an awesome day
remote programming and training
strive4peace2006 at yahoo.com
*