Auto complete a field when another is selected

[ps32208]

Hi there,

I have a table saved which holds a customer's name and the account manager associated. In my form I want to pick a customer in one field and have the account manager field auto populated.

I have no idea how to do this, can anyone help?


Pete

 

[CautionMP]

ps32208,
Is your Form in any way, shape, or form connected to a Recordset that contains both fields?

CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[PHV]

Use a ComboBox

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886