Changing a SubForms SourceObject

[GGleason]

I have made the supposition that you can change the SourceObject when you have a toggle button on a form. Here is part of the code for the Click event:
[tt]
frmIdfProcSub.SourceObject = IIf(togIdfLocDups.Value = True, _
"frmIsoControlSub4qryIDFlocationDupLocs", _
"frmIsoControlSub4qryIDFlocation&quot
[/tt]
It successfully changes the subforms SourceObject, but the data does not change at all. Is my supposition incorrect or am I missing a step?

tia,
GGleason

 

[scriverb]

Your assumption is correct. But, you must perform a requery of the subform to refresh the data with the new source object.

me![frmIdfProcSub].requery

That should do it.

 

[GGleason]

Thanks for the suggestion. But what I eventually did in my case (because of other factors) was change the record source instead of the object source, which worked. I could do that in this case because the field information was identical to the other query.

GGleason