Is there a way to keep a user from bring able to enter a record in a subform, or giving a message if they try to add a record to a subform, when a certain value/field is null on the main form? The subform consists of a combo box and they do not have to click a cmd button to access the subform. The field in the main form is also a combo box.
My user has a tendency to skip the main form and enter the info into the subform and then forget to enter the info into the main form all together. I do have required fields built into the table, but because she is closing the form without entering any info into the main form, it doesn't kick in the required fields. She thinks she's entered a record but it's incomplete.