CODEWITHSUNDEEP
vbams-accessms-access-2007
Bawn
Bawn

Reputation: 509

How to stop access trying to save record when you exit

I have a form that isn't for adding or deleting , just checking if a record is in the database. Every time I try to close the form access try's to save the record to the database and then throws an error because there is already a record of the same values in the database.

How do I stop access from trying to save the record? I have tried Me.Dirty = false and Call Me.Undo in the onClose event. But none of these seem to work , any other ideas ?

Upvotes: 1

Views: 708

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123419

As per comments above, adjusting the properties of the form to make it "read-only" (e.g., Data Entry, Allow Additions, Allow Deletions, and Allow Edits all set to False) solved the problem.

Upvotes: 2

Related Questions