Subform refreshing

V

Virgil

I have two subforms on the same form that pull data from
the same source, a linked child table. One shows all
people assigned to a project (subform1), the other is for
reassigning people to the same project (subform2).
Subform1 refreshes immediately when I change a name
already assigned to the project (via subform2) but doesn't
show any change when a new record is added in subform2. I
have to go to a different record on the main form then
come back to see a change. I've tried several methods in
the subform2 control to Requery the data in subform1,
mostly using the same approach:
(save the record) DoCmd.DoMenuItem acFormBar,
acRecordsMenu, acSaveRecord, , acMenuVer70
(requery the subform) Me.Parent!subform1.Requery
On Lost Focus, On Change, Before Update, and On Exit do
not work. Any suggestions?
 

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