Form Creates Blank / Unwanted Records.

[Josef]

I have several forms and am linking each form via their employee id.

some forms point to tables where records are not required for each user,
such as disability information.

when i scroll through the forms and complete inputting data, i notice
that when i look through the table, there are empty records (except the
PK employee id) listed in the table. any suggestions as to why this is
happening?

The update seems to happen when the Disability form closes??

thanks.

 

[Allen Browne]

If you dirty the new record, it will be saved. That could happen if the user
types anything, OR if you programmatically set the value of any field.

If you cannot track down the cause, another workaround to prevent the record
being saved would be to open your table in design view and set the Required
property to Yes for one of the fields. Then Access is unable to save the
record unless this field has a value.