A query is not going to do that for you. You need an update or append query
to add the record for you. You would have to write some code to automate
that, but there is a simpler way. Build your append query and if your query
returns no results, have a command button to run the append query.
--
Milton Purdy
ACCESS
State of Arkansas


"JudyKemp" wrote:

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!