Go to new record if no results

M

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
 
R

Rick Brandt

Mike Rotch said:
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?
Click to expand...

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