I'm using access 97.
I have a form on which the user enters information. This information is entered to a query via a add record button.
When users do not enter information into the building and chemical controls, I get a message when trying to view reports that says "no current record". So what I have to do is go into the query and delete those records with the missing information.
Is there a way to set up the form so that you cannot add a record unless certain controls on the form have been completed?
Another words, I do not want anyone to be able to add incomplete records...
Hope this is enough info...
Thanx
Gustavson
I have a form on which the user enters information. This information is entered to a query via a add record button.
When users do not enter information into the building and chemical controls, I get a message when trying to view reports that says "no current record". So what I have to do is go into the query and delete those records with the missing information.
Is there a way to set up the form so that you cannot add a record unless certain controls on the form have been completed?
Another words, I do not want anyone to be able to add incomplete records...
Hope this is enough info...
Thanx
Gustavson