Cannot add records to subform

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.
 
P

Pendragon

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.
 
J

John W. Vinson

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top