Linking a text box to another through input

[ccholai]

Hi,
Need some help in this - I have a form which has a combobox -
recommendation no and then a text box - description of recommend.

The Recom. no is selected which should show the associated desc in the
text box.
the desc of recommendation and the recom no is in a table - which is
not part of the form.

at the mo, the #name? error is showing in the rec desc text box.

please assist - thanks

 

[Marshall Barton]

Need some help in this - I have a form which has a combobox -
recommendation no and then a text box - description of recommend.

The Recom. no is selected which should show the associated desc in the
text box.
the desc of recommendation and the recom no is in a table - which is
not part of the form.

Assuming that the description field is included in the combo
box's RowSource query as the second field, just set the text
box's control source expression to:
=thecombobox.Column(1)

 

[ccholai]

Thanks Marsh - but I would like the recommendation desc to show up on
the form in a separate text box.

 

[ccholai]

Hey Marsh,

Thanks heaps for your help - disregard my previous reply...... didn't
read through it well enuf!! :-(
It works !!! thanks again!!

now i can carry on.....