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
 
B

bhicks11 via AccessMonster.com

You put the criteria in the query that you create in the record source. So
in the query, reference the control on the form that has the department you
want (or don't want) to show.

So the criteria would be:

forms!thisform.departmentcontrol

Bonnie
http://www.dataplus-svc.com
 
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

Link a text box based on drop down box with four options MS Word 365 0
Drop down list control value in vba 2
Combo box 0
Based on value from 1 combo box filter results in the next combo b 2
Formatting combo box drop-down list 2
Advanced Drop Down List Option 0
Look up Name based on ID 4
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1

Top