Go to new record if no results

  • Thread starter Thread starter Mike Rotch
  • Start date Start date
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
 
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.
 
Back
Top