Using a combo as the recordsource for a subform

[davidcantor]

I have a form with a subform when the main form opens the subform is set to not visible. when a selection is made from a combo box i want the selection to be the recordsourse for the subform

I have a variable vSelected and have assigned the sql for the recordsource to it with the cmbo box as the criteria
then I have the code to assign the string as the Recordsource of the subform.

with this line

Code: Select all

Forms!Form1!sfExpense.RecordSource = vSelected

when I run the code I get an error message: Run time error '438' Object doesn't support this property or method

[HansV]

You have to specify explicitly that the recordsource is a property of the Form object in the subform control:

Forms!Form1!sfExpense.Form.RecordSource = vSelected