How to AutoFill from a combo box ???

[lookup13]

I have a the following fields in my table :

Supplier---Address--phone---fax--

I made a form using these fields ,(there are more fields customer etc.)It like a order form .

I would like to use a combo box for supplier,and pick the vendor (which I did )--But i would like to take it a step further --When I pick the vendor it would Auto fill
phone and fax boxs --Can you do this ?


For example :

pick vendor : ABC
phone 555-1212
fax 555-1313

Any Ideals ?

Thank you for your Time!!

 

[cghoga]

Try the DLookup function.

Enter your code in the Control Source of the phone and fax fields.

You should be able to lookup the phone and fax based on the vendor name.

 

[lookup13]

Thank you for the tip , I will give it a shot...