Combobox

[freddy]

I have two ComboBoxs in a from. The first combobox contains categories and
the second is subcategories.
If I pick laptops from the first combobox, I want the second combobox to how
me the items for the laptop and not the whole list. I have a lookup table
with an fk from the sub combobox related to the pk of the first combobox.

 

[Ofer]

Check this link
http://www.databasedev.co.uk/filter_combo_boxes.html

Or, you can apply the filter in the second box row source refering to the
first combo

Select Field1,Field2 From TableName Where Field3 =
Forms![FormName]![Combo1Name]

And on the after update event of combo1, run the code
Me.Combo2Name.Requery