datasheet behaves different than form (1 Viewer)

mitchem1

Registered User.
Local time
Today, 07:07
Joined
Feb 21, 2002
Messages
153
Hello all,
I put some very simple code in a form. When a user tries to save a record or move to a different record, a dialog pops up that asks them if they are sure they want to save changes. It works just fine in the form. However, I have a user that likes to switch to datasheet view and do a lot of data entry that way. She gets prompted to "save changes?" after every field, not just when moving to a different record. I have no idea where to begin with this problem. Any ideas would be greatly appreciated. Thanks.

-mitch
 

mitchem1

Registered User.
Local time
Today, 07:07
Joined
Feb 21, 2002
Messages
153
It is in the Before Update event.
 

missinglinq

AWF VIP
Local time
Today, 08:07
Joined
Jun 20, 2003
Messages
6,423
Is this app divided into a front end/back end configuration?

If so, is the validation code in the Form_BeforeUpdate event? Or in the BeforeUpdate event of each field?

If the former, I would suspect that the front end in the errant PC has become corrupted, and would start off by replacing it with a copy that is working properly.

Linq ;0)>
 

Users who are viewing this thread

Top Bottom