Restrict Double Posting.Not Allow Inventory items to be posted twice?

[burrina]

I have a subform that runs code to subtract from inventory items sold. The fields are;
ProductID 'Name of Product
Quantity 'Quantity of Product
UnitPrice 'Price of Product
Discount 'Discount
Extended Price 'Extended Price with discount applied


Status 'Default is None and other value is Allocated.


The code is run off the ProductID

How can I then prevent a user from posting this amount twice?
The user can add items and choose to either post them now or later.
The form is a continuous form.
It along with subtracting those items from inventory sets the Status to Allocated from None, which is the default.

What if the user needs to edit the record, what then? I assume some kine of Before Update Event !
Also, not sure if this helps but Primary Key is named OrderDetailID

[burrina]

I solved the issue: Here is what I did.
If Me!OrderStatus = "Allocated" Then 'Checks to see if Status of Order has already been set to Allocated, NO Double Inventory issue.
MsgBox "Order Has Already Been Posted"
Exit Sub
End If


Still have to give some thought to what if user Changes the Record and saves. They don't Post to Inventory but do change the Order Product,Quantity,Price,etc...
If they don't Post, no error checking is in place.They can save however and the Status will be set to Awaiting Approval.Next dilemma is they delete a record? This will of course NOT adjust Inventory. Unsure of how to handle these things.