I've got a subform that's in a datasheet view as it will be a list entry for my user. My problem is when you go into a form, it has an autonumber ID and is related to the Job Number, and so these fields populate. They are Hidden of course cause they aren't what I'm concerned with, so it essentially creates a blank record. When I run reports these of course show up and I don't want them to.
Is there a way to code this to not create a record until the field is clicked on? Or would a better way to solve this problem be to create a delete query to delete all of the records that are blank in a required field when a report is ran?