G
Guest
When adding data to a new form and its subforms, the records' links aren't
synchronized. Both are autonumbers. I have no problem with the tables and
subtables relating. I have no trouble with existing records relating. For
example, I've entered data into a main form's text boxes and it is assigned a
unique autonumber, its "ID." I enter data into a blank record in a subform,
whether a dropped-in subform or command button pop-up, and it is assigned a
unique autonumber, its "ID." The two "IDs" do not relate. In this case they
need to be the same number but aren't. I was able to synchronize existing
records between forms with macros. How do I synchronize a record that doesn't
exist yet?
synchronized. Both are autonumbers. I have no problem with the tables and
subtables relating. I have no trouble with existing records relating. For
example, I've entered data into a main form's text boxes and it is assigned a
unique autonumber, its "ID." I enter data into a blank record in a subform,
whether a dropped-in subform or command button pop-up, and it is assigned a
unique autonumber, its "ID." The two "IDs" do not relate. In this case they
need to be the same number but aren't. I was able to synchronize existing
records between forms with macros. How do I synchronize a record that doesn't
exist yet?