Recordset Connection

[zach.taylor.12]

I'm getting an error in the following code, which attempts to connect
to a recordset:

Set rstReportPage1 = New ADODB.Recordset

strQuery1Name = "qryResultsPage1_FormInput"

' Get the page 1 data into a recordset
rstReportPage1.Open strQuery1Name, CurrentProject.Connection

This worked fine until I changed from a hard-coded name of the query to
the strQuery1Name variable.

Can you help?

 

[JethroUK©]

Dim strQuery1Name as string