At most one record can be returned from this Subquery

SELECT [SkID], [SkName] AS [Prerequisite], "Skill" AS [Type]
FROM [tblSkills]
WHERE [SkID] = (SELECT [preSkID] AS [SkID] FROM [qryLINK_Skill-Skill] WHERE [qryLINK_Skill-Skill].[SkID] = [Forms]![frmSkillsAddEdit]![SkID]);

What did I do wrong...???

The where clause can only have 1 criteria unless you have an OR clause in there. Is it possible that your subquery is returning more than one record?. If you only want 1 value, have you considered using a Dlookup?

UNION Queries

SELECT qryPrerequisiteSelected.PreID, qryPrerequisiteListing.Prerequisite, qryPrerequisiteSelected.Type
FROM qryPrerequisiteListing INNER JOIN qryPrerequisiteSelected ON (qryPrerequisiteListing.Type = qryPrerequisiteSelected.Type) AND (qryPrerequisiteListing.PreID = qryPrerequisiteSelected.PreID)
WHERE (((qryPrerequisiteSelected.SkID)=[Forms]![frmSkillsAddEdit]![SkID]));

I just use two union queries...
Thanks for the help tho...