On Wed, 19 May 2010 16:21:01 -0700, JudyKemp
wrote:

No, you'll have to do that in two steps. First test if records exist,
then based on the answer show the first record or a new record.

Depending on your exact situation sometimes you can get lucky. For
example if you have a form in FormView and you apply a filter, it will
automatically show the first matching record or if none found it will
show an empty record where you can enter new data.

-Tom.
Microsoft Access MVP


I have a parameter query works as long as there are related records in the
tables. My problem is I when the query results are "null" or no records
exist I want the query to automatically create a new record based on the
parameter input. Is this possible?

Example:

[CustomerID] criteria shows Like "*" & [Enter Customer ID:] & "*"

If this is a new record for this Customer my query returns no values. I
want the query to automatically create a new record for this Customer or show
all records related.

Your help is GREATLY appreciated!