At 5:11 you talk about using a DLookUp for a specific type of address or phone number.  I need to know how to do that.  I built my original forms based upon tables with (for example) OfficePhone, CellPhone etc as separate fields.  I have now gone back and put all the phone numbers in one table with a TypeT containing a TypeID and such things as Office, Cell, Fax, Home etc.  Same sort of thing for email, address, Title (this is a DB for teachers in a school where one may be on two or more faculties and be Professor in one and Artist in Residence on another).  Anyway, my DLookup for such things as phone numbers no longer works.  I need to specify which is Office and which is Cell, etc.  I have tried to use a Where condition using an "AND" clause where an ID = Combo ID AND TypeID = 1 (I know I have not done the right syntax here) but I get a "mismatch" error in the second part of the AND clause.  I do not understand that since TypeID is a number and "1" certainly is an number.  I do NOT put "" around 1 but Access does.  Long question, I know, but it is one I am wrestling with right now.  Further, since this deals with teachers in schools, I also need to narrow the result to a specific school where the student is enrolled.  That may be beyond the scope of this class, but it is my problem.  Especially since I have gone back and redone my tables to make phone numbers (for the teachers, at least: thinking about doing it for the Students/contestants as well as the people in the town where the competition is held!!; same for addresses, emails, etc).  Anyway, I need to do what you said at 5:11.  Excellent Seminar.  I have listened to it many times.  It takes repeated hearing for me to learn it.  But after two years, I am beginning to grasp some of it!!

---

Reply from Alex Hedley:

Why not just create a Query that uses the CustomerID to filter on (with the others) and have it as SubForm.