programming a combobox and textbox on Acces form

[viba via AccessMonster.com]

i am starting in programming and I would like your help. i created a form
Access on which i have a combobox with two fields, one containing text field
and the other containing the values of the text are numbers.

Then i created a textbox and my story is that I would like that every
selection of a recording in my combobox, the value or number associated with
it is affected in the texbox. Successively values must be added in the
textbox to each selection.

Help me please

 

[Al Campagna]

viba,
Not sure if I understand your question. Please show us some sample combo
box values, and what you want to do, after a selection is made.
But anyway...
For example, if your combo (ex. name cboClient) has a selection like
this.
Column-0 Column-1
"Joe Smith" 12345
(combo columns are numbered 0, 1, 2, 3, etc...)
To display what is in the second column of your combo in a text box on
the form, place this in the ControlSource of that text box...
= cboClient.Column(1)
So, when you select "Joe Smith", the textbox will show 12345.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."