Understanding Delete

[Guest]

I have a table with 3 fields making up primary key. If someone clicks the
new record button and then decides they want to scroll to a previous record,
they get the 'Index or primary key cannot contain a null value' message. I
assume that's because in order to scroll to a previous message the one they
just created needs to be saved firt and one or more of the key fields is
null. Correct?

If, at that point then, a user decides they would like to delete the
incomplete record, they click Edit/Delete and still get the 'Index or primary
key cannot contain a null value message'. How can they delete a record that
doesn't have one of the primary key fields completed? Thanks.

 

[Roger Carlson]

They can't delete the record, because it hasn't been saved. They have to
UNDO the record or hit ESC key.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Undo rather than Delete.

 

[Rick Brandt]

I have a table with 3 fields making up primary key. If someone
clicks the new record button and then decides they want to scroll to
a previous record, they get the 'Index or primary key cannot contain
a null value' message. I assume that's because in order to scroll to
a previous message the one they just created needs to be saved firt
and one or more of the key fields is null. Correct?

If, at that point then, a user decides they would like to delete the
incomplete record, they click Edit/Delete and still get the 'Index or
primary key cannot contain a null value message'. How can they
delete a record that doesn't have one of the primary key fields
completed? Thanks.

You can't delete a recrd that was never saved in the first place. Have your
users press Escape a couple times when they want to "cancel" the record that
they started, but never saved.

 

[Guest]

All very helpful - thank you!

You can't delete a recrd that was never saved in the first place. Have your
users press Escape a couple times when they want to "cancel" the record that
they started, but never saved.