Combo Box Drop-down list is based on specific data


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
 
Ad

Advertisements

A

ADB_Seeker

I found the answer. I had to add WHERE to my SQL statement to get the combo
box to filter on a specific department.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top