Returning fields from a combo-box

[Guest]

I have an order form with an OrderDetails subform. Within this subform I
have; Products, UnitPrice, CostPrice, Quantity, LineTotal, CostLineTotal

Products is a combo-box where I want the UnitPrice and CostPrice to come up
in their fields as specified within the Products table when I choose a
product. The UnitPrice comes up ok but the CostPrice doesn't. When I switch
around the two prices in the Products table, CostPrice will work but
UnitPrice won't. When I change the column count of the Products combo-box to
4, I can see both the prices but the 2nd price won't read in for me. As this
CostPrice won't read in, my query for CostLineTotal won't work and so I'm
stuck. Where am I going wrong?

Thanks in advance,
JohnnyF

 

[Arvin Meyer [MVP]]

There are 3 elements to the columns in a combo box:

1. Row source: Select statement or query
2. Column Count
3. Column widths property

It sounds as though your column widths need adjusting.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

Hi,
Thanks for the help. Sorry, I explained it poorly. On clicking in the
Products combo-box, I want that product's UnitPrice and costPrice to come up
in their fields, i.e

Product UnitPrice CostPrice Quantity LineTotal CostLineTotal

The UnitPrice works fine but I have to type the CostPrice manually and as a
result I can't sum the CostLineTotal at the end because it's unbound. Any
ideas?

Thanks again for your help,
Johnny

 

[Ken Snell \(MVP\)]

Perhaps this article will assist:
http://www.mvps.org/access/forms/frm0058.htm

 

[Guest]

Brilliant. That's exactly what I need. thanks a million