How can I link the combo box to the edit box

[studentZ]

Hi,
I have a form that there is a combo
box and an edit box. I have a table with Customer ID, Company Name and
Country. I want to do that when my combo box chooses an item(eg
McDonald in Company Name) in the form, the edit box can show another
item (eg USA in Country) after the trigger. How can I do that? I've
tried to do so, but the edit box still cannot show the related item,
but only blank to let me enter info.
Thx very much!
Raymond

[Jeff Pritchard]

Make sure you combo returns the Country in a column - it can be hidden by
setting that column width to 0.

In the Control Source for the text box put -

=NameOfCombo.Column(ColumnIndex)

ColumnIndex is a 0 based index. Count the column from left to right 0,1,
etc.

Jeff Pritchard
________________
Asken Research Pty. Ltd.
Access Database Developers
www.asken.com.au

"studentZ" <is*********@yahoo.com.hk> wrote in message
news:3d**************************@posting.google.c om...

Hi,
I have a form that there is a combo
box and an edit box. I have a table with Customer ID, Company Name and
Country. I want to do that when my combo box chooses an item(eg
McDonald in Company Name) in the form, the edit box can show another
item (eg USA in Country) after the trigger. How can I do that? I've
tried to do so, but the edit box still cannot show the related item,
but only blank to let me enter info.
Thx very much!
Raymond

[Looking for Work]

"studentZ" <is*********@yahoo.com.hk> wrote in message
news:3d**************************@posting.google.c om...

Hi,
I have a form that there is a combo
box and an edit box. I have a table with Customer ID, Company Name and
Country. I want to do that when my combo box chooses an item(eg
McDonald in Company Name) in the form, the edit box can show another
item (eg USA in Country) after the trigger. How can I do that? I've
tried to do so, but the edit box still cannot show the related item,
but only blank to let me enter info.
Thx very much!
Raymond

Please visit: http://www.mvps.org/access/
They are always looking for work.
Schill Willingly