Reference another column in a record (1 Viewer)

[Greyowlsl]

Hi,

I have a form that has a combo box (box1), Its row source is from a table (table1) than the forms record source (query1). The data box1 sources is from column1 in table1.

I then have a text box (box2). I need it so when i select a record in box1 (from column1) that it displays the corresponding data in that same record (and table) but from column2

Example:

A table has a column with equations and another column with the answer.

I select "1+1" in the combo box
Then in the text box it displays "2"

Thanks guys

 

[John Big Booty]

Use the following as the Control Source of your unbound text box;

=YourCombo.Column([B][COLOR="Red"]x[/COLOR][/B])

Where x represents the column that hold the data you wish to display in the text box. The column must form part of the row source of the combo, but need not necessarily be visible. Also remember that the columns in your combo are numbered from zero on up.