Combo Box Question

[mwood]

Is there a way to use multiple combo boxes to look up a record?

For example each employee can send several faxes to different companies. Each record has the employee, company, date, etc.

Can I use a combo box to select the employee, another combo box to select the company, etc?

If so what is the best way to set that up?
I'm using Access 2000 if that helps.

Thanks for the help!

 

[THoey]

I have done something like this before. I created a lookup table that held the information (region, state, city, etc). Then I had three combo boxes, one for region, state and city. A query loaded the region combo box with the other two greyed out. Based on the region selected, an after update event ran a query and loaded the possible states into the state combo box. Finally, when they selected a state, an after update event ran a query and loaded the possible cities into the city combo box.

I am sure I still have this code around here if you need more help than that...

Hope this helps.


Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?