Picture tells it all.. Thanks for suggestions..
Database Combo Filters Listbox.accdb
Picture tells it all.. Thanks for suggestions..
Database Combo Filters Listbox.accdb
For the combo, use DISTINCT
SELECT DISTINCT FieldName FROM TableName.
The he filtering can be done a couple of ways:
http://www.baldyweb.com/CascadingCombo.htm
- I would create a third table showing only the options for system (AB, AC and AD) and them link them, to the other tables
- Create a query of that third table, exactly the same, not filtering anything
- in the form, create a combobox selecting only the "document system short" values of that query
- create a second query for the filtering showing the following columns:
- document system short
- document name
- document system
- in criteria of this second query, put this formula in the column of document system short: [forms]![frmStart]![Name_Of_Your_ComboBox_Here]
- in the form, create the listbox using the columns "document name" and "document system" of the second query
that should make it work