If is occurs in Access 2002 Service Pack 3, then it is a known bug.
Temporarily comment out any error handler handler so your code pauses at the
error. Note the error number. In the error handler part of your code, just
ignore that error, i.e. insert:
If Err.Number <> xxxx Then
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"hebandgene" <sammi90@yahoo.com> wrote in message
news:1107472699.275599.214400@c13g2000cwb.googlegr oups.com...[color=blue]
> When I delete a record in a subform I get the warning that I'm about to
> delete a record, followed by an error "No current record." When I
> click OK obviously the record is deleted and it goes to the first
> record (as I've coded it to do) or it shows me a blank record if the
> deleted record was the only one.
>
> So, what I'd like to do is bypass that 'No current record' altogether
> to avoid user confusion. Is there any way to code it out without
> ignoring my error handling?[/color]
