Append & Sub Queries

Hey All (Again)
 
I'am trying to do this:
 
INSERT INTO tblTeams ( TeamName, FK_TeamLeader, TeamNotes, Created, Modified )
SELECT [p_TeamName] AS Expr1, (SELECT tblUsers.UserID FROM tblUsers WHERE tblUsers.UserIdent =  [p_TeamLeaderName] ) AS Expr2, [p_TeamNotes] AS Expr3, Now() AS Expr4, [Expr4] AS Expr5;
Note: the Subquery - I'll recieve the error RESERVED ERROR (-3025) THERE IS NO MESSAGE FOR THIS ERROR
 
Any suggestion to solve the problem appr. ( NOT USING VBA )
 
Kind regards
Johnny Emde Jensen
 
Loading