Deleting the most recently added record

G

gemma charters

I have a very simple form and am adding command buttons using the wizard to
delete a record. I add a record, go to it, then try to delete it and I can
do this but I get a message saying 'no current record'. This seems to happen
only if I am trying to delete the most recent record added. If I delete the
second or third or penultimate, then I don't get the message. This is very
annoying. I thought I would be able to find a solution in this forum but no.
Surely other people have this problem? Please help
 
A

Allen Browne

If this is Access 2002 SP3, then trap and ignore the error number. This is a
known problem with this version.
 
G

gemma charters

Thanks. Is there an SP which fixes this?

Allen Browne said:
If this is Access 2002 SP3, then trap and ignore the error number. This is a
known problem with this version.
Click to expand...
 
A

Allen Browne

No. The last SP for A2002 *causes* the problem.

It's not too hard to add error handling to avoid that Err.Number though.
 
Top