G
Guest
Here's the issue: I have a main form with a subform on it. The main form's
record source is called "tblMainForm" with one field in it-MainFormPK-the
primary key. The subform's record source is another table called "tblSubform"
and it has three fields-SubformPK (the primary key), MainFormPK (foreign key)
and DataEntry-a standard text field.
I want to create a new record so I open the main form and am immediately
brought to the subform's text box whose control source is DataEntry. I enter
something into the text box and close the form. What I entered into the text
box is saved in tblSubform but the main form did not create a new record
therefore MainFormPK was not automatically entered as the foreign key in
tblSubform and there is no link between the forms. (By the way, the Master
and Child fields are set properly.)
My question: Is it mandatory that the main form containing a subform have a
data entry field? If not, does anyone know of a way around it? Thanks for any
help.
record source is called "tblMainForm" with one field in it-MainFormPK-the
primary key. The subform's record source is another table called "tblSubform"
and it has three fields-SubformPK (the primary key), MainFormPK (foreign key)
and DataEntry-a standard text field.
I want to create a new record so I open the main form and am immediately
brought to the subform's text box whose control source is DataEntry. I enter
something into the text box and close the form. What I entered into the text
box is saved in tblSubform but the main form did not create a new record
therefore MainFormPK was not automatically entered as the foreign key in
tblSubform and there is no link between the forms. (By the way, the Master
and Child fields are set properly.)
My question: Is it mandatory that the main form containing a subform have a
data entry field? If not, does anyone know of a way around it? Thanks for any
help.