No Current Record Query Error

webmeister · February 2nd, 2011, 05:42 PM

I am having an issue when I have more than one record being returned. I get a "No current record" error message.

However if I only have one record being returned it works without any issue.

My query's SQL is below.
Any idea as to what is causing this issue?

Code:

SELECT tblRegistration.regRecordID, tblRegistration.stuID, tblTestSession.tsSession, tblRegistration.regApptChange, tblRegistration.regNoShow, tblRegistration.regAutoAppointment, tblRegistration.regTaken, tblRegistration.regDateofReg

FROM tblTestSession INNER JOIN tblRegistration ON tblTestSession.tsID = tblRegistration.tsTestSession

WHERE tblRegistration.regRecordID = (SELECT tblRegistration.regRecordID 
FROM tblRegistration LEFT JOIN subqryRegistrationWithResults ON tblRegistration.regRecordID = subqryRegistrationWithResults.regRecordID
WHERE (((subqryRegistrationWithResults.regRecordID) Is Null)))

HiTechCoach · February 2nd, 2011, 06:18 PM

Is the issue when the subquery returns more than one record?

webmeister · February 3rd, 2011, 01:42 PM

Yes. it is.

webmeister · February 3rd, 2011, 01:49 PM

When I use

Code:

 
WHERE tblRegistration.regRecordID IN (SELECT tblRegistration.regRecordID ....

works but when I put it into my union query it locksup and feezes Access.

HiTechCoach · February 3rd, 2011, 03:43 PM

Are you changing the putting the sub query to a union query that is returning multiple records?