I am attempting to use the following code:
Set recSource = CurrentDb().OpenRecordset("select * from qryCut_Over_Details where " & _
"[loop] = '" & strLoop & "'")
The problem is that it only returns a recordsource with a recordcount = 1 even tough if I build a query with the same SQL string I get a list of 50 odd entries. Why would the VB code only return a single entry?