Bobadopolis
No I can't fix it dammit!
- Local time
- Today, 15:59
- Joined
- Oct 6, 2005
- Messages
- 77
Hi All,
I would like a form (in Access 2000) that allows users to search the database using combo boxes that specify criteria. So, upon load the form would be populated by every record, then as the user begins to make selections using the combo boxes they can narrow the results down to only a few (combo box filters are cascading; each one narrowing the results the other returned). There would also obviously need to be a reset button and 'all' fields in the combo boxes. I have found the code to filter by 1 combo box but if more than 1 is added (obviously) the filter resets to filter only by the current selection. (See the method I used here)
Does anyone know how to bolt these together so they work in sync?
Please be gentle as I've only been learning Access for 2 months and VBA is still very new to me
Thanks,
Bobadopolis
I would like a form (in Access 2000) that allows users to search the database using combo boxes that specify criteria. So, upon load the form would be populated by every record, then as the user begins to make selections using the combo boxes they can narrow the results down to only a few (combo box filters are cascading; each one narrowing the results the other returned). There would also obviously need to be a reset button and 'all' fields in the combo boxes. I have found the code to filter by 1 combo box but if more than 1 is added (obviously) the filter resets to filter only by the current selection. (See the method I used here)
Does anyone know how to bolt these together so they work in sync?
Please be gentle as I've only been learning Access for 2 months and VBA is still very new to me
Thanks,
Bobadopolis
. Could be interesting...
