Column Property

[Coulmn Property]

I am trying to create a form that has a subform. The main
form is the information for a Project. The subform is the
detail cost items related to the project in a many to one
relationship.
So far the form seems to work correctly.
I have created a combo box that is based on a table. It
will be on the subform. The table has a list of items and
prices, each related to the project. My intention is to
use the combo box to select an item from a table and drop
it into the detail table of the subform. For this purpose
I am trying to use the column property.
In the MS Access help there is a description of the use of
the Column Property. I think I understand the process, at
least some. However I can't seem to see where I can enter
the
expression.column(Index,Row).
When I look at the properties of the Combo box I see:

Column Count
Column Heads
Column Widths

are any of these the place to type the expression.column
(Index,Row)
Any suggestions would be appreciated.

Thanks,
Jack

 

[Cheryl Fischer]

Access Help (and VBA Help) could be much better organized! For a better
description of how to use the Column property in a combo box, search the
Index in VBA Help on "column". Probably, you'll see a list containing
"column" and "Column" - select the capitalized item.

Generally speaking, to use a multi-column combo box to supply values to
other controls, you should use the AfterUpdate event of the ComboBox. For
example:

- The combo box on your form is named cboItems
- First column is bound to ItemName
- Additional (second) column is ItemPrice and is unbound

In the AfterUpdate event of the combobox, insert the following code to
update a textbox control named "ItemPrice":

me!ItemPrice = me!cboItems.Column(1)

Note that in VBA the column numbering starts with 0, while on the property
page for the combo box, it starts with 1.

hth,