How do I create a drop down using Access 2007 Form?

I had a look at your information. As I have little of the remainder of your database to fully understand the extent of it, I will tell you that I recommend you create a tblServicersContacts, with fields like firstname, lastname, phonenumber, extension, cellphone, email, title and I would leave the autonumber field in there, and also have a field called ServicersID. On my Servicers form I would have a subform called Contacts where this datasheet would be displayed. I would create a combo box that would be for your primary contact only, it would have a control source of primary contact in your servicers table, and a rowsource of a sql statement that looked up the contacts from the table for drop down list.

Hope this helps,

Dan

P.S. Let me know if you need some help with this, I can give you some information to read on some of it.

Am at work at the moment, will try and look at it when I get home tonight.

Dan

I looked at your example last night and have an abundance of questions for you:

What exactly are you trying to accomplish with this database?
Are servicer assignments each time you get a service call or is that a company?
Do you do repeat business with a company?
Are some contacts ever used for more then one company?
Are the contacts people in your organization or theirs?

These are just a few that change how things are setup.

Look forward to hearing from you.

Dan

Glad to hear!

Dan