hi
The following sql command gives me an error 'Can return at most one record.' It was working fine until now. i have no clue why it stopped working. any ideas please??
Thanks
The following sql command gives me an error 'Can return at most one record.' It was working fine until now. i have no clue why it stopped working. any ideas please??
Code:
DoCmd.RunSQL "UPDATE Courses SET Courses.Required = TRUE " & _
"WHERE Courses.CourseID = (SELECT WorkgroupCourses.CourseID FROM " & _
"WorkgroupCourses WHERE (WorkgroupCourses.WorkGroup = '" & wg & _
"' OR WorkgroupCourses.WorkGroup = 'Basics') AND " & _
" WorkgroupCourses.CourseID = Courses.CourseID)"
Thanks