calculated field in a form

[Penny]

I am trying to calculate a field in a form. I have a table that has the fields

Product _ID
Product Name
Product Price

I have an unbound combo box which selects a produce name. I am then
creating a calculated field in my form which calculates the area multipiled
by the price of the carpet. My calculation =[Combo22]*[Area of Carpet
required] works but from [combo22] picks up the product_id and not the
product price. How can I tell my caluclation to pick up the 3rd field rather
than the 1st one?

 

[Ken Snell \(MVP\)]

=[Combo22].Column(2)*[Area of Carpet required]

The Column property of a combo box (or list box) allows you to read/use a
value from a column other than the bound column. It's a zero-based property,
so Column(0) is the first column, Column(1) is the second column, etc.