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
DoCmd****nSQL "DELETE FROM Cabin_Temperatures WHERE Cabin_Temperatues.[CT_Comp] Is Null"
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!