query problem

[Bidhan]

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

UPDATE Stock SET Stock.qty = nz([Forms]![Add Parts]![qty])+nz([Forms]![Add Parts]![qtyBuy])
WHERE (([Forms]![Add Parts]![partsNo]=[Stock]![partsNo]))

[MMcCarthy]

I have moved this post into it's own thread as it is not part of the thread it was on. You are more likely to get a response to your query this way.

Also, I have edited the email address you gave as giving a proper email address means it's likely to be picked up by a trawling engine and hijacked for spamming purposes.

Moderator

[PEB]

Hi in fact there is simultaneous write on the respective record
I suggest you to create a Qty field in your form that can be hidden if you don't want to be visualised and in the Lost Focus Event write an event procedure like this:
Me!qty = nz([Forms]![Add Parts]![qty])+nz([Forms]![Add Parts]![qtyBuy])

Hope this helps!

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

UPDATE Stock SET Stock.qty = nz([Forms]![Add Parts]![qty])+nz([Forms]![Add Parts]![qtyBuy])
WHERE (([Forms]![Add Parts]![partsNo]=[Stock]![partsNo]))