Query on a form new record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I am creating an acces db and i have a query that is behind a form, i run
this query which filters down to one record using a unique quote number. The
problem i have is that when it is filtered you cna scroll and add a new
record using this form, i dont' want the user to be able to do that i want
them only to be able to see that record and def not add a new one. How can i
get my query or form to stop showing this blank record?

I have already took allow additions and data entry off the form but that
doesn't work. I know i can stop the scroll working on opening the form but i
wanted another way really one that stop the query appending the blank record.

Cheers

Danny
 
If the form's allow additions property is set to no, you shouldn't be able
to scroll to a new record on a form. So there is a problem there. How are
you opening the form? Are you using VBA code that looks something like the
code below?

DoCmd.OpenForm "",acNormal,,,acFormPropertySettings
 
Hi

The problem is that the form is runnnig on a query that takes all the value
from table x and any corresponding values from tables y and z but if tables y
and z don't have the values then and they are empty then it allows me to
create a new record.

How it works is that a quote is created and eventually that becomes a job
and is linked to the job but before then the job number field is empty and
its when this is the case that you can scroll to a new record.

Is there anyway to cure this?

Cheers

Danny
 
Back
Top