Hi,
I have a table (Stock) important field are partsNo., des, qty, pPrice, sPrice, qtyBuy. I make a query based on the table and has one more field SAB(qty+qtyBuy) . I made a form based on the query. User can enter data in any field. When I enter data in ‘qtyBuy’ field I can see the added value by SAB field.
My obligation is to set this value into stock table in qty field. To perform this action I run an action query in a macro...

Hi
I have a form (Add Parts) based on a table (Stock). Table has qty (stock in hand) and qtyBuy field related to the form that I want to update. I want an action query to update qty field. I write the query in a macro and I set it on qty lost focus event but it sometime show the new value sometime show message “Writing Conflict”
Please tell me the solution.
Thanks.
hbidhan "AT" yahoo "DOT" com
...