Filter combo box?

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

If I had a table with following fields & data.

for example,
Type Item Size
===============
A inkjet A3
A inkjet A4
A laser A3
A laser A4
B dot A3
B dot A4
.........

And i will make 3 combo box in the form for user to select:- Type, item,
size.
Can i make it like a filter function as Excel provided ?

For example,
If user choose [A] for [Type], then it only provide [inkjet] & [laser] for
[Item] instead of list out all of them and so on........

thanks !
Joe
 
If I had a table with following fields & data.

for example,
Type Item Size
===============
A inkjet A3
A inkjet A4
A laser A3
A laser A4
B dot A3
B dot A4
........

And i will make 3 combo box in the form for user to select:- Type,
item, size.
Can i make it like a filter function as Excel provided ?

For example,
If user choose [A] for [Type], then it only provide [inkjet] & [laser]
for [Item] instead of list out all of them and so on........

thanks !
Joe
Click to expand...

Code the 'AfterUpdate' event of the 'Type' combobox and enter...

ItemCombobox.Rowsource = "Select <fields> FROM <ItemTable>
WHERE TypeID = " & .TypeCombo

Now, when you select a Type, the Item combo will only show related items.

Ray Keattch
 
Back
Top