Go to new record if no results

[Mike Rotch]

Here's what I have -
I have a form (frmProduction) that references a query
(qryProduction). My table (tblProduction) has a date
field that is indexed (no duplicates).
My query has a criteria of "[What production date?]".
The question comes up and is able to open the form with a
filter to the date that was typed.

Here's what I need -
If the date they typed doesn't match any records, I want
it to go to a new record with the date they typed in the
date field.

Is this possible?

thanks.
Mike

 

[Rick Brandt]

Here's what I have -
I have a form (frmProduction) that references a query
(qryProduction). My table (tblProduction) has a date
field that is indexed (no duplicates).
My query has a criteria of "[What production date?]".
The question comes up and is able to open the form with a
filter to the date that was typed.

Here's what I need -
If the date they typed doesn't match any records, I want
it to go to a new record with the date they typed in the
date field.

Is this possible?

If your query is updateable (many are not) then this is what should happen
automatically.