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
DCount("[CourseIDF] ", "tblCourses", "[CourseIDF] = " & me.cboCourse _
& "[UG/PG]", "tblCourses", "[UG/PG] = UG) = 1
Rich