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
 
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

Similar Threads

Based on value from 1 combo box filter results in the next combo b 2
Look up Name based on ID 4
Formatting combo box drop-down list 1
combo box with parent table 2
Select where form's combo column holds the info? 4
Label based on drop-down box selection 3
Pop-up Calendar on Combo box drop-down arrow Click 2
Combo Box & Report Questions 22

Top