The record you are referring to does not exists. It is more of a user interface thing than a record. Even when you start typing into Access this record does not exist until it is commited. so if the user starts typing and then presses escape the record is never added.
It seems odd that this would cause a problem and I would think the problem lies else where. Could you highlight which line is causing the problem?
I tend to use this technique for selecting random records :
select a list of all the primary keys I want to include for my random selection.
create a random number from 1 to the number of records.
get the primary key that corresponds to the random number and select this record.
e.g.
selection of primary keys :
PK record number
3 1
5 2
6 3
8 4
4 5
2 6
random number 1 to 6 ..... 4
get the full record for record number 4 - primary key 8
The reason I only select primary keys is because it is a rapid and small select with an index. then once I know the record(s) I can do a PK lookup on the full record which again is fast and avoids pulling all the records details accross before I know which record I want.