Hi All

I've developed a huge headache over this silly problem.
I have an update query that updates a field from adding 2 listboxes in a form together(=[txtQty1]+[txtQty2]).
For some reason when I try to use an expression in the "Update to" field in the query builder, the calculation doesn't work and only include the one value rather than both added together.
I've also tried to use a hidden textbox on the form that has the controll source set to =[txtQty1]+[txtQty2]. This textbox displays the correct sum of both previous mentioned textboxes added together.
When I use this hidden textbox in my "Update to" field still, the quantity showing in the query is only from one textbox rather than the two added together.

What am I doing wrong?

Cheers / Fred

Can you post your code?

Hi stu9820
This was the first and easiest variation of the code.
Forms Text2 is where a pallet id is entered.

UPDATE tblWH
SET tblWH.Qty = [Forms]![frmPalletConsolidate]![txtQty1]+[Forms]![frmPalletConsolidate]![txtQty2]
WHERE (((tblWH.Pallet)=[Forms]![frmPalletConsolidate]![Text2]));

It looks like you might be trying to do math with strings? Have you tried changing the "text" quantities to numbers to add them properly?

Well, I put in a 3rd textbox with the row sourse set to =[txtQty1]+[txtQty2] and it adds them up fine, but when I put the 3rd textbox in the Update to: field in my update query, all that happens when I run it is that it returns the already existing value for the record I want to update instead of the new value in the 3rd textbox.

I've also set the the textbox property Format to General number.

Any ideas?

Cheers / Fred

Have you tried:

UPDATE tblWH
SET tblWH.Qty = Forms.frmPalletConsolidate.Form.txtQty1 +
Forms.frmPalletConsolidate.Form.txtQty2
WHERE (((tblWH.Pallet) = Forms.frmPalletConsolidate.Form.Text2));


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division