Having problem with a Update-query...

[marlun]

Hello!
I have a problem with a update query. I have a form that adds records to my DB. I fill in an amount in the form "AmountIn". I want it to add the "AmountIn" with the Amount in the table. Seems to me it's pretty easy, but it doesn't work.

The query's criteria is a S/N. And it is connected to the form. And the Update: [Amount]+[Forms]![Add]![AmountIn]

Please help

/marlun

 

[WildHare]

Are you ADDING records, or UPDATING existing ones? I can't really tell from your post.

Can you post the full SQl from the query, if it's not too ponderous?

J
Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm