Cannot add records to subform

  • Thread starter Thread starter tc2004
  • Start date Start date
T

tc2004

I have a form with a subform (linked by drag and drop). The main form has a
"Add New Record" button. When I add a new record via the button, I can enter
info in the main form, but not in the subform.

How can I fix this?

Thanks.
 
Since the button is on the main form, the new record goes to the record
source of the main form. To go to a new record on the subform, either move
the 'Add New Record' button to the subform, or programmatically (VBA) change
the add new record reference to work on the subform instead of the main form.
 
I have a form with a subform (linked by drag and drop). The main form has a
"Add New Record" button. When I add a new record via the button, I can enter
info in the main form, but not in the subform.

How can I fix this?

Thanks.
Click to expand...

By correcting the problem with the subform...

which we cannot see.

I'm guessing that the subform's Recordsource is not updateable, but that's
just a guess.
 
Back
Top