At most one record can be returned by this subquery. (Error 3354)

[Spocks]

Hi and thank you in advance. I'm trying to create a listbox that populates on the following query however i get the following error.

At most one record can be returned by this subquery. (Error 3354)

This is my SQL:

SELECT Students.[Student ID], Students.[Student Name]
FROM Students
WHERE (((Students.[Student ID])=(SELECT [Student ID]
FROM [Student_Sports]
WHERE [Sporting Team] = [Forms]![SV_Teams]![txtTeam])));

 

[spikepl]

So what is unclear in the answer you found with google?

 

[Spocks]

I'm found no answer on google that's why I'm here...