Blank Record

D

danc09

Using A2K. What is the best way to prevent adding blank records to a
database? I have changed the AllowAdditions property to False and required
the user to press a command button to add a record. However, if the user
changes their mind and leaves the form, a blank record has been added, since
there is no requirement to press a Save button. I certainly think there has
to be a way and I just do not understand it.
Also, for later reporting, the user wants the current date to automatically
be entered in a field when the record is added. Adding the date is not a
problem, but making sure the record is not otherwise blank seems to be.
Thanks for any assistance.
Dan
 
A

Allen Browne

Open the table in design view.

Set the Required property to Yes for one of the fields.
 
S

storrboy

Using A2K. What is the best way to prevent adding blank records to a
database? I have changed the AllowAdditions property to False and required
the user to press a command button to add a record. However, if the user
changes their mind and leaves the form, a blank record has been added, since
there is no requirement to press a Save button. I certainly think there has
to be a way and I just do not understand it.
Also, for later reporting, the user wants the current date to automatically
be entered in a field when the record is added. Adding the date is not a
problem, but making sure the record is not otherwise blank seems to be.
Thanks for any assistance.
Dan
Click to expand...


Add a date field with the default value set to Now().
Set the Required property to True on at least one other field (other
than an automunber field).
The record cannot be added unless the required field is supplied.
 
Top