Drop Changes Message

[Ben]

Environment Info:

- MS Access Sales System (front-end)
- SQL Server Standard (back-end)
Information of the Problem:

** In the Inventory items data:
- when user enters a new item and does not
encounter problems entering it, the subsequent changes to the item
information will not cause any problems

- when user enters a new item and encounters problems during the
entry stage, the subsequent changes to the newly entered data will
cause a "Drop Changes" error

To quick fix the situation of the problem, I had to help the user and make
changes to the item information directly at the back-end.

Does anyone have an idea where to start in fixing the problem?

Thanks!

[Whyteboar]

Ben,

What type of problems are encountered that cause the issue?

SQL has a save acceptance verification that you could look for on a save, but
if it's simply a data entry correction issue I'd start by putting in input
masks or field validation properties to improve your odds of getting solid
data the first time.

HTH,

Craig

Ben wrote:

>Environment Info:

- MS Access Sales System (front-end)
- SQL Server Standard (back-end)

Information of the Problem:

** In the Inventory items data:
- when user enters a new item and does not
encounter problems entering it, the subsequent changes to the item
information will not cause any problems

- when user enters a new item and encounters problems during the
entry stage, the subsequent changes to the newly entered data will
cause a "Drop Changes" error

To quick fix the situation of the problem, I had to help the user and make
changes to the item information directly at the back-end.

Does anyone have an idea where to start in fixing the problem?

Thanks!