update record in table

[rehanemis]

Hi,

I would like to update a Stock table using another form field.

I am using update query and writing the statement as below in query design (update to).

([tblItemsStock].[InStockQty]+[Forms]![frmAddItemsQty]![AddQty])

It is not working and updating 0 record.

any idea?

 

[boerbende]

If you make it first more simple to narrow down to the problem.
Update first the table column to the same value... so remove the form field part in the query
I guess you have already a problem there, but then you know your update query is not corrrect. If you get it work, then add the form field

Ben

 

[Frothingslosh]

"Not working" doesn't really tell us a whole lot. If you can, tell us the actual error message you're getting, because the issue could range from a primary key violation to you having created a non-updatable query to any number of other things.

My suggestion would be that if boerbende's suggestion doesn't help, then post the exact error message you're receiving as well as the SQL statement for your update query.

Also, updates can function as appends if they can't find a record to update, and if your query is going into append mode but you haven't submitted required fields, then that would also prevent it from working.