Populate Text Box With A Seletion From A Combo

[Lee24]

I have a customer database with the usual; fields name, address, telephone etc. What I am trying to is let the user select a customers name from a combo box and from that selection the other text boxes (address, telephone etc) are automatically populate with the customers details.

Can anyone give any help!



Thanks In Advance

 

[GingerR]

in the underlying query/table for the combo box, display all the fields you want displayed after the combo box selection, i.e. Name, Address, Tel, etc

set COLUMN COUNT accordingly
make the column widths be 0" for ones you don't want showing when the user clicks on the combo drop-down arrow (i suppose this is all but NAME from what you said).

then, in the control source property of the unbound text boxes that you are using to display address, telephone, etc, you can reference the columns of that underlying table/query (start with 0)

=[cboCOMBO].[Column](0) will show the 1st column of your combo box dataset
=[cboCOMBO].[Column](1) will show the 2nd column of your combo box dataset
=[cboCOMBO].[Column](2) will show the 3rd column of your combo box dataset

etc.

substitute your combo box name for 'cboCOMBO'

g

 

[RickSpr]

Check out the following Microsoft FAQ:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q100132&GSSNB=1

If none of those techniques work for you, come back and explain more about what your form is for, what its record source is, etc. Rick Sprague

 

[Lee24]

Thanks Guys,

It works like a dream, something else I have learned. Must say that this site is superb for finding answers!