Hi,

This is a basic question, but Access' online help is NO help.

I want to run an append query like the following:

DoCmd.OpenQuery "Append_New", acViewNormal, acEdit

If this append was successful then I want to run further code, else I
want to exit.

If I use error trapping, that doesn't work. For instance, when I run
the "Append_New" append query and there is a key violation, that is
not considered an error, yet I still want to exit.

There MUST be a way to trap the success or failure of a statement a la
UNIX.

HELP PLEASE....