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.