Select Source Object subform

[sergiomb]

Hello,



I have a form called SEARCH_MATERIAL_FORM, which contains a subform called Mechanics. I need the subform Source Object to change when I select a value in a combobox called MasterGroupList. The source object should be a query called MaterialsMasterGroup

Right now I have this:


Private Sub MasterGroupList_AfterUpdate()


Me!Mechanics.SourceObject = "MaterialsMasterGroup"


End Sub

But I get this error:

Run-time error '2101':

The setting you entered isn't valid for this property

Someone knows what am I doing wrong?

Thanks

[ranman256]

The comb box will have 2 fields,the caption for users, and the subForm name.
make sure the combo columns property is 2, and bound to col 2.
user picks an item, then set the source.

sub cboBox_Afterupdate
  subFrm.controlsource = cboBox
end sub