C
Chuck
The subform works fine until I click a command button that says Add New on
the main form.
The subform is created from the linking table of "many to many" relationship.
The subform consists of the Primary key of the main form, and the Primary
key of another table.
The main form provides all the controls ready for new data, including the
Primary key.
The subform will not allow a new record without the Primary key from the
main form.
The main form does not get the Primary key until it is actually saved to the
table (the Primary key is an autonumber field).
How can I get the main form to obtain its Primary when clicking the Add New
command button, so that the subform has the Primary key in the new record?
the main form.
The subform is created from the linking table of "many to many" relationship.
The subform consists of the Primary key of the main form, and the Primary
key of another table.
The main form provides all the controls ready for new data, including the
Primary key.
The subform will not allow a new record without the Primary key from the
main form.
The main form does not get the Primary key until it is actually saved to the
table (the Primary key is an autonumber field).
How can I get the main form to obtain its Primary when clicking the Add New
command button, so that the subform has the Primary key in the new record?