Multiple Filtered Drop Downs Revisited

[Thales750]

I've been using Popup Dialog Boxes or unbound controls in the Form, with some insert code, for years to display Combo boxes filtered by other Combo Boxes.

If you have better ways, how would that work?

 

[CJ_London]

The term generally used is ‘cascading combos’. Google to find plenty of examples - there is one example in the similar threads at the bottom of this thread

 

[MajP]

May find this interesting.

Solved - Unbound Combo box need multiple value

Hi, I have a searcher form. It is worked. But now like to put multiple value to search. CODE : Private Sub cmdFilter_Click() Dim strWhere As String Dim lngLen As Long If Not IsNull(Me.fltCompanyName) Then strWhere = strWhere & "([CompanyName] = """ &...

www.access-programmers.co.uk

This is not cascading, but multiple fields with multiple selections per field.