I'm trying to get a Count of the records "rstTemp". The problem seems to be when I use the Where clause in the SQL source. If I just specify the Table [Qry-Export Summary] as the source or Select * from [Qry-Export Summary] I am able to get a record count. When I insert the Where clause the record count returns 1 when I know there are more records.
Dim db As Database
Dim rstTemp As Recordset
'--- The following only returns a record count of 1?
Set rstTemp = db.OpenRecordset("Select * From [Qry-Export Summary] Where LAYOUT_ID = 'migl606r.sqr'")
x = rstTemp.RecordCount