combo box with specify data dropdownlist

**herukuncahyono** · 04-12-2009, 10:07 PM

Hi, I have Table there are two type of list , "A" type and "B" type...
I have two form and there are combobox inside. form #1, I want in combo box dropdownlist are only "A" type in list and on Form #2 ,only "B" type on combobox list.. can We do like that..with access ???

Thanks

**bhill** · 04-17-2009, 08:35 AM

For each row source, you will need to add a WHERE statement to your SELECT statment. Here is an example for 'A':

SELECT Table1.Name, Table1.type FROM Table1 WHERE (((Table1.type)="A")) ORDER BY Table1.Name;