Hi Richard,
I have learnt so much from 302 but still have one little problem. My data base lists all the courses available at a University along with the entry rrquirements. Each of the departments have a set of entry requirements and they apply to all courses pertaining to their department, so when a new course is set up DLook up makes my life so much easier. However one department has different levels of language requirements for various courses. Basically I want to run my DLookup to populate most of the fields but when entering a new course for this 'rogue' department I want to be able to choose the language condition rather than have it populated automatically. Is that possible?

---

Reply from Richard Rost:

Susan, I'm sure it's possible. I don't know how you have your database setup, but you could just code it inside of an If/Then block of VB code.

If DepartmentID = 105 Then
  'do crazy department stuff here
Else
  'do rest of departments here
End If