Update a table record from querry

[Markvand]

G'Day

I have the following querry:

SELECT TblProducts.ProductID, TblProducts.HarnessNo, INQCuttingTimeTPZ!Expr1/TblProducts!HarnessNo AS ExprA, FROM (((tblProducts INNER JOIN INQCuttingTimeTPZ ON TblProducts.ProductID = INQCuttingTimeTPZ.ProductID)

On the form, I have a text field: Number of Harnesses (HarnessNo), the form is joined to a querry. My idea was, to allow user to enter the number of harnesses and then recalculate all the times. I was thinking of storing the HarnessNo in a TblProducts, but I can't edit the text field on the form.

I've checked all the options, is it possible to store a value from a text field to a table from querr, which uses calculations and other querries?

Hope I'm clear enough here, if not I'll explain it again.

Help would be highly appreciated, as always

Regards

Mark

 

[Markvand]

Sorry for such a late reply,

You need to determine if its the query or the form which is causing the problem.

It's a query problem Pat,

I reckon it is something related to calculated fields, I've checked with another query based on the same table but without these calculated fields and it works fine.

What should I do, I need all these fields.


Regards

Mark