Selection from Drop Down Menu

[coolcatkelso]

Hiya

I have a drop down menu with my Customers Name in, is there a way I can also have it select the address?

The form is like this :-

Appointment Date:

Appointment Time:

Customer: (Drop Down)

Location:

The Customer Name and Location would be pulled from another table, Customers?

Cheers

CCK
________
Lovely Wendie

 

[pbaldy]

Make sure the address is in the second column of the combo rowsource, then in the after update event of the combo

Me.Location = Me.ComboName.Column(1)