Empty records showing in my table

[DixieThunder24]

I have a work order system that people use but it somewhat randomly puts blank records into my table. I've added a lot of validation checks when submitting, closing and resetting the form and limited the way people can exit out of the form to help fight this issue but it still happens.

Any ideas why this is happening? The code is fairly long with everything thats on the form but I can copy it if it needs to be seen to know whats going on.

 

[jdraw]

How do you define a blank record? If you have an autonumber PK, I would think you would have at least a Primary Key. If you make some fields mandatory, I'm not sure how a casual user could ignore/get around it.

Tell us more about your underlying table design, and some details of your validation checks.

 

[DixieThunder24]

You are correct. The table does have the autonumber field, date and work order number that all are automatic. It just doesnt have all the fields that are required by the user to enter. So my "blank" means everything thats not automatic, sorry.

The table as a autonumber PK like you mentioned then a number of fields that hold info based on what the user enters.

My form loads up and checks to see what the last work order number was and sets the new work order number to that + 1 and sets the date. When the user hits the submit button it goes through a number of if statements to make sure none of the required fields at null or blank strings.

I diabled the close button on the form but the actual Access close button is still enabled. If they use that to close the system witht he form open I believe that will cause my record to be "blank". I had code that would disable that as well in a different system and thought I copied it to this one but I guess not.

You think there is any other way I could be getting blank records?

 

[spikepl]

Sounds like your validation is not up to scratch. Play with the attached db.