S
spacerocket
I have a PO db, and for the OrderNo, I put the following in BeforeUpdate of
the Form:
Me.OrderNo = Dmax("OrderNo", "PO_Table") + 1
For the workgrp access, I plan to have a Data Entry user (insert data only)
and a Full Data user (edit/modify/delete). The issue I'm thinking now is; if
the Data Entry user incorrectly enters some info in the PO, the Full Data
user will open the same PO to edit it. Will the OrderNo be changed when the
latter edits and save the PO? How do I prevent this?
the Form:
Me.OrderNo = Dmax("OrderNo", "PO_Table") + 1
For the workgrp access, I plan to have a Data Entry user (insert data only)
and a Full Data user (edit/modify/delete). The issue I'm thinking now is; if
the Data Entry user incorrectly enters some info in the PO, the Full Data
user will open the same PO to edit it. Will the OrderNo be changed when the
latter edits and save the PO? How do I prevent this?