Changing RecordSource to Query Name

[Bill Bisco]

I would like my code to work like this:

strQryName = "qryProcessSelectCurrentLSSubform"
Forms!frmProcessSelectLSRS![frmProcessSelectLSSubform].RecordSource = strQryName

However, I get an error. I am aware of this example:

Sub cmboCompanyName_AfterUpdate()     
Dim strNewRecord As String     
strNewRecord = "SELECT * FROM Customers " _         
& " WHERE CustomerID = '" _         
& Me!cmboCompanyName.Value & "'"     
Me.RecordSource = strNewRecord 
End Sub

Is there any way to change the record source of a form to a specific query without copying the query's SQL code?

Sincerely,
Bill

 

[pbaldy]

I think it's just an incorrect reference to the subform:

http://www.mvps.org/access/forms/frm0031.htm

 

[Bill Bisco]

My goodness, I'm such a noob.

Thanks,
Bill

 

[pbaldy]

No problem; we all do it.