Hi friend,
actually, i have been tried by event procedure after update something like this;
If Me.UnitsConsumed > Me.CodeNo.Column(7) Or Me.CodeNo.Column(7) = 0 Then
Else
MsgBox "Hi Friend your quantity issued exceed with quantity stock on hand, please see your superior for updating records...", vbCritical, "Materials & Procurement Management System"
Me.Undo
End If
When my colleggue update for example enter 4 pcs eventhough stock on hand is 2 then msg come up like above but the problem is when we enter 2 pcs or 1 pc the msgbox also come up like that.
would your have any idea to solve this problem?
I looking to hearing a best reply from yours.
Best regards
actually, i have been tried by event procedure after update something like this;
If Me.UnitsConsumed > Me.CodeNo.Column(7) Or Me.CodeNo.Column(7) = 0 Then
Else
MsgBox "Hi Friend your quantity issued exceed with quantity stock on hand, please see your superior for updating records...", vbCritical, "Materials & Procurement Management System"
Me.Undo
End If
When my colleggue update for example enter 4 pcs eventhough stock on hand is 2 then msg come up like above but the problem is when we enter 2 pcs or 1 pc the msgbox also come up like that.
would your have any idea to solve this problem?
I looking to hearing a best reply from yours.
Best regards