Nesting inside COMBO BOX

[Ray W.]

I have a combo box with many entries that could be put into categories, i.e.
Surgery, Radiology, Lab, etc.
I'm looking for a way in access for the user to easily navigate to their
department in the list then select from the department specifc list rather
than scrolling through the 30+ entries.

-Ray

 

[John Vinson]

I have a combo box with many entries that could be put into categories, i.e.
Surgery, Radiology, Lab, etc.
I'm looking for a way in access for the user to easily navigate to their
department in the list then select from the department specifc list rather
than scrolling through the 30+ entries.

The simplest way to do this might be to have two combo boxes on the
form, one for department, one for the list appropriate to that
department. An explanation of how to do this can be found at

http://www.mvps.org/access/forms/frm0028.htm


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps