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