I have a main form w/ two subforms in Access. Based on their parent/child fields, the subforms call up existing matching records. My problem is: when there is no matching record in my subform it automatically creates a new record and populates it with whatever is entered in the parent field on the main form. I would like the user to be able to add and edit records on the main form regarless if there is a match on the subform or not. When there...