I'm creating a simple report of a product listing which includes the product,
various labor data, unit cost, unit list price, and UNIT OF MEASURE. Unit of
Measure is selected from a list box in the Product table. The problem I have
is that each record on the report shows the entire value list, not the one
that is selected as in the table. I have tried using both the table and a
query as the report's record source, but get the same results. How do I get
only the field's selected value to display in the report?
Any help is appreciated!
Duane Hookom - 30 Nov 2005 23:06 GMT
Don't use a listbox control on your report. Use a text box or combo box.

Signature
Duane Hookom
MS Access MVP
--
> I'm creating a simple report of a product listing which includes the
> product,
[quoted text clipped - 8 lines]
> only the field's selected value to display in the report?
> Any help is appreciated!