How to refer to a specific record in a query

[Greyowlsl]

Hi,

I have a form which has a number of text boxes that need their value multiplied by their corresponding value in a query.
The query has a product field, and a product count field.

Example:
Text1 has a label called wood1 (the product), so i need text1 to lookup wood1 in the query (product field) and then get the corresponding value (product count) and multiply it by the value in text1

Thanks,
Leon

 

[MStef]

As I can understand you, I think you don't need a query.
Look at "DemoProductCountA2000.mdb", (attachment, zip).
Look at Table1, Form1. Open Form1 and try.
Adapt it in your MDB.

 

[Greyowlsl]

Hi MStef, thanks for the reply

Unfortunately the database wont run, most likely because i am running access 97, which i think is incompatible.

 

[MStef]

OK, here it is Access97, (attachment, zip).