Auto populate a text box

[mkelly]

I have a combo box that brings up a "client ID #" I also have a text box for "client Name" Can anyone tell me how to auto populate the client name once an ID# is picked in the combo box??

any help appriciated.

 

[ColinEssex]

Why not have the ClientName in the ComboBox?

Col

 

[Fizzio]

Add the client name to the rowsource query of the combobox. In the textbox, set the controlsource to =Forms!NameofForm!NameofCombo.column(column where name is -1)

you take 1 away from the counted column as they start from 0.

 

[mkelly]

thanks