Rundown:

Database with multiple forms. On the home page is a modal form that allows the opening of multiple forms based in selections with 5 txtboxes. The data that is inputted into the 5 txtboxes is copied over to corresponding txtboxes to the forms that open up.

If the user were to close the multiple forms at this point, the data in the txtboxes would be saved as a new record. Which I don't want but have resigned to the fact it's going to happen.

Before this all I had to do was
CT_Comp is a text field at the very end of the form that's blank if the above happens. And usually the above SQL works fine.

For some reason, when I implemented the "open multiple forms and copy data from modal form into the fields on all the forms that opened as a result" thing...the SQL code no longer works.

I've tried modifiying the code to include blank space, spaces etc to no avail.

The solution I want:

Either prevent the incomplete records from saving to the table. OR
A code that deletes incomplete records from the table with a button. Possibly a loop that goes through and finds all records where CT_Comp is blank/null/spacey and deletes them.

I've tried to make this a clear as possible but realize if you can't see the project there is probably going to be some comprehension issues to what I'm asking. I'll be happy to answer any questions and thanks for your help in advance!

Dunno why the code has all those asterisks are there. Should be DoCmdR.u.n.SQL

It keeps putting astricks there so disregard the periods.

what defines a row as being incomplete
..wahtever that is, translate into VBA and place int he before update event of the form
if the row doesn't validate then don't allow the row to be added/updated

the asterisks appear because we were innundated with spam promoting a roumanian website that ended in ru. so dot ru got obliterated to encourage 'em to go away in short jerky movememnts

An incomplete record is any record that has a blank field. All fields are required in order to submit the record. The way that the incomplete records are saved is when the Home button is clicked which is just a simple close event.

If I understand you correctly, I should clear the record:

I grasp that I should do a BeforeUpdate() event such as:

set the cancel flag (the return value from the function to true if you want to cancel the update)
BeforeUpdate Event [Access 2003 VBA Language Reference]
...use the forms before update event NOT the control's before update

you may also want to provide some user feedback whether thats a message using msgbox or chaneg colours of the relevant controls is up to you

An incomplete record is any record that has a blank field. All fields are required in order to submit the record. The way that the incomplete records are saved is when the Home button is clicked which is just a simple close event.

If I understand you correctly, I should clear the record:

I grasp that I should do a BeforeUpdate() event such as:

I guess I'm not understanding the BeforeUpdate() event

place your validation code int he forms before update evemt

eg