Populating Data

[cStar07]

Hi,

I have a combo box link with the data in "TABLE A". "Table A" has 3 fields - Account Number; Name; Address. How do i link the data of each respective field's data to be reflected on each textbox?

For example :when i select "kely" from the combo box then "kely" will be reflected on textbox1; "kely"'s Account Number will be reflected on textbox2 and "kely"'s Address will be reflected on textbox3.

 

[bjackson]

set each text boxes controlsource

=me.[comboboxname].column(1)
=me.[comboboxname].column(2)

 

[ColinEssex]

or alternatively

In the AfterUpdate of the ComboBox put

Me.YourFieldName = Me.ComboBoxName.Column(1)
Me.YourOtherFieldName = Me.ComboBoxName.Column(2)

Remember that the ComboBox columns start at 0.

So Column(0) will be the AccountNumber posted in the ComboBox, Column(1) will be the name and Column(2) will be the address.

Col