Syntax probs

Howlsta

Vampire Slayer
Local time
Today, 15:11
Joined
Jul 18, 2001
Messages
180
I want to check if a course selected from a cbo is in the category UG or PG. CourseIDF and UG/PG are in the same table. I'm trying to use a dcount, but keep getting the syntax wrong. Both fields are numbers. Anyone spot the problem.

DCount("[CourseIDF] ", "tblCourses", "[CourseIDF] = " & me.cboCourse _
& "[UG/PG]", "tblCourses", "[UG/PG] = UG) = 1

Rich
 

Users who are viewing this thread

Back
Top Bottom