R
rbchildrn
Hello! I have a data entry form with two subforms. They are based on
three separate tables keeping different kinds of information on
individuals. The main form shows contact info, subform1 shows donation
info, subform2 shows volunteer info.
I can't figure out why when information is updated in the main form,
the subforms are not updatable. The record navigation buttons aren't
greyed out, but the fields in the subform cannot get focus. (I am
using datasheet view.) However, the subforms work fine when there is
no change in the main form. Right now if I need to change info across
the main and sub forms, I have to close and reopen the form after
changing the main info to get the subforms to take data. I have tried
using a "save record" button and requerying the form in VBA (on Dirty,
after update), with no result.
The forms are linked correctly, the subforms update the appropriate
records in the appropriate tables when they are working, I just need to
be able to make changes across the main and sub forms without having to
close and reopen the form.
Strangely, I have another form with a similar setup that captures
company information, and all the forms work fine. I don't know what
would make the difference.
Let me know what other info you need! Thanks a lot.
three separate tables keeping different kinds of information on
individuals. The main form shows contact info, subform1 shows donation
info, subform2 shows volunteer info.
I can't figure out why when information is updated in the main form,
the subforms are not updatable. The record navigation buttons aren't
greyed out, but the fields in the subform cannot get focus. (I am
using datasheet view.) However, the subforms work fine when there is
no change in the main form. Right now if I need to change info across
the main and sub forms, I have to close and reopen the form after
changing the main info to get the subforms to take data. I have tried
using a "save record" button and requerying the form in VBA (on Dirty,
after update), with no result.
The forms are linked correctly, the subforms update the appropriate
records in the appropriate tables when they are working, I just need to
be able to make changes across the main and sub forms without having to
close and reopen the form.
Strangely, I have another form with a similar setup that captures
company information, and all the forms work fine. I don't know what
would make the difference.
Let me know what other info you need! Thanks a lot.