Hi Kenneth

I found my error.

I was repeating the same variable @HamTeamsID, when it was supposed to be @PosID!

so

where (HS_Players.fk_hamTeamID = @HamTeamsID or @HamTeamsID <> 0)

and (HS_Players.playerName = @Name or @Name <>'')

and (HS_Players.playerSurname = @Surname or @Surname<>'')

and (HS_Players.fk_hamTeamID = @HamTeamsID or @HamTeamsID<>0)

has to be amended to

where (HS_Players.fk_hamTeamID = @HamTeamsID or @HamTeamsID <> 0)

and (HS_Players.playerName = @Name or @Name <>'')

and (HS_Players.playerSurname = @Surname or @Surname<>'')

and (HS_Players.fk_posID = @PosID or @PosID<>0)

Thanks for your help!

Johann