Hi Richard,

sorry I was not clear with my last post. I work at a University and keep details of all our courses on a data base. We also include the name, email address and ext no of the peson in each department who is our contact. This is the DLookup I use at the moment:

Private Sub DptContacts_AfterUpdate()


EmailAddress = DLookup("emailaddress", "Contacts2", "ID=" & DptContacts)
ExtNo = DLookup("extno", "Contacts2", "ID=" & DptContacts)

What this does is when I update contact details for a department, I just update the department contact and then that persons email address and ext no are updated also. What I want to do is for example, if we have a department contact who uses two ext nos, one for 3 particular courses and a different one for all the others, then I dont want that persons ext number added automatically, I want to be able to choose.Do you think the easiest way would be to just add a second record to the table containing the department contacts but just change the name slightly so I can recognise which ext this will add. Sorry if I am getting all complicated.

Thanks for your patience so far.

Susan