Combo Box Drop-down list is based on specific data

  • Thread starter Thread starter ADB_Seeker
  • Start date Start date
A

ADB_Seeker

I have a table (ASSIGNEES), which has four columns (ID, ASSIGN-NAMES,
EMAILADDRESS, DEPARTMENT). I need to set up a combo box that only shows the
names associated with a specific department when I click on the drop-down
arrow. For example, anyone with a department of MGT will not show in the
drop-down selection and anyone with a department of ENG will show up.
Thank you in advance for your help.
Linda
 
I found the answer. I had to add WHERE to my SQL statement to get the combo
box to filter on a specific department.
 
Back
Top