Error 3021 Add New Record Question

[Bill Johnson]

I'm building a form to perform a table search then open a form with the
results of the search. The search is based on three criteria and is working
as an SQL statement.

When the record does not exist, I will get a 3021 error.

Is it better to perform a test for the record first, then populate a new
record, or allow the error to trap the problem and create a new record in my
error handling routine?

1. I'm not sure how to test for the null record (using ADO) and when I get
that part all happy,

2. I'm not sure how to create a new record using ADO - I can always call an
Append query.

Thanks for any help you can give.