Revising Subform's Record Source

G

Guest

I have written a macro in an attempt to revise the record source of a
subform. I have an SQL statement that returns what I want, but the line I
have to revise the subform keeps pulling up the error screen with the words
"Object doesn't support this property and method". Any suggestions?

Forms.frmMain.frmSub.RecordSource = strSQL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form and subform weirdness when linking to SQL Server 2005 via OD 2
Dynamic Sub Form Record Source 7
subform based on external SQL won't requery 1
Subform not displaying records 1
subform record source tabbed page 2
Change source in a Subform 2
Duplicate record in Form and Subform 0
open subform no records 1

Top