Displaying distinct data

[Greyowlsl]

Hi,

I have a query that has 2 fields, product and quantity

I want a form that has a text box for each product, with the quantity in the box and the product as the label.

Is this possible?

Thanks,
Leon

 

[John Big Booty]

In the form's On Current event use;

Me.LabelName.Caption = Me.Product [COLOR="Green"]'or whatever the product field is called[/COLOR]

 

[Greyowlsl]

OK, but how do i have 1 text box (with data source: Quantity) to show the quantity of product X and another text box to show the quantity of product Y. I tried having {SELECT... FROM... WHERE product="X"} in the default value property, but it doesn't work, only works on combo boxes or list boxes.

Attached is a screenshot of the query design and the form where i have a list box working to display the amount, however i want each products amount displayed in separate text boxes, and no list box.

 

[John Big Booty]

Have you considered a continuous form?

 

[Greyowlsl]

Well, if this works, it will be a subform for another form. However i need to make a calculation on that main form that uses the the product amounts (from the form we are discussing) multiplied by that products 'multiplier' (on the main form).

Product X amount (subform) multiplied by Product X multiplier (mainform)
Product y amount (subform) multiplied by Product y multiplier (mainform)
and so on... for every product

The problem is i somehow need to identify each product, which I'm not sure how you can do that on continuous form, all i know is how to target text boxes, like me.textbox1 (product X) multiplied by me.textbox2 (product X).

Also this is in access 97.