RecordSource Property of a form

[mkc80]

I am trying to set the Record Source of a subform to a query like this:
Me!Copysubform1.RecordSource = LSQL

LSQL is the query string
Copysubform1 is the subform

I get the following error:
Object doesn't support this property or method.

Actually the subform1 is bound to a table.

I have written this code in the OnChange event for a combobox on my main form. So when I change my selection in the combobox, the subform should display the record from the table if one exists, or else I should be able to fill the subform (which should be empty when the combobox selection value doesn't already exist in the table)

FYI: I have tried many variants for setting the recordsource property I found on various sites, but no luck

[pbaldy]

Does this work?

Me.Copysubform1.Form.RecordSource = LSQL

[mkc80]

Nope. Doesn't work.
I get the error: "This expression is typed incorrectly, or is it too complex to be evaluated. For example, a numeric expression may contain too many complicated elements ......"

[pbaldy]

Well it likely worked and revealed the next problem. That sounds like a problem with the SQL. Try this to help debug it:

http://www.baldyweb.com/ImmediateWindow.htm

[John_G]

Hi -

You need to use the name of the main form control containing the subform, not the name of the subform itself. So if for example the name of the control is SubFormControl1, you wou have:

Me.SubFormControl1.Form.RecordSource = LSQL

What confuses a lot of people is the fact that the name of the subform is not used at all in this context.

John