Combo box choice filling in second text box.

[Robin Hickman]

I have two combo box questions, I'll post in separate messages. This is
the second:

I know I've seen this, but I can't find it. I have a combo box on a
table that looks up an item from a table. I want the another text box
to automatically fill in the price based on that choice. (the price is
stored in the same table as the item that the combo box looks up. I
know this is common and simple, but I'm not finding it.

Thanks,
Robin

 

[Wayne Morgan]

With the price in the same table as the item, just include the price field
in the row source of the combobox. Set the width of this column to zero so
that it won't show in the combobox. Set the textbox control source to a
calculation that refers to the column in the combobox.

Example:
=cboMyCombo.Column(2)

The column number is zero based, so column one is zero, column two is one,
etc.

 

[Robin Hickman]

Thanks, I thought it was probably someting that simple!

Robin