benallen002
Board Regular
- Joined
- Feb 16, 2005
- Messages
- 65
I'm trying to figure out a way that would allow users to create a custom WHERE clause for a form that is bound to a table that has alot of fields. The table contains alot of records as well, but the user usually only needs to work with one subset of records at a time. I could put ALL of the fields on a "filter by" form and run it before the real form, but most of the time the user will only need to filter on one or two fields, and it seems like a waste of both load time and code running time to check all, say, 30 controls for values. The other problem is that the form I want to filter on contains not only textbox controls, but also combobox controls, which of course are linked to ID fields that the user doesn't know.
Anyways, I've gotten so far as to mark all controls whose ControlSource I want to be able to filtered with a tag, and I've got the code that gathers all those controls up into an array, I just can't figure out what to do next.
Any thoughts?
Anyways, I've gotten so far as to mark all controls whose ControlSource I want to be able to filtered with a tag, and I've got the code that gathers all those controls up into an array, I just can't figure out what to do next.
Any thoughts?