[AccessD] Filter by Form stuff

Arthur Fuller fuller.artful at gmail.com
Tue Apr 15 18:32:39 CDT 2008


I have on my form of interest a pair of combo-boxes that enable the user to
find stuff quickly. The form also has a set of buttons that invoke the
Filter-By-Form stuff. The former and latter parts work well, but not in
conjunction. I have written some code that examines the filter after the
Filter-By-Form stuff executes, and the results are weird. Everything begins
with "Lookup_*", where "*" refers to the controls you filled in while
addressing the Filter-By-Form form.

I need to deduce whatever filter the user applies and then re-scope the
"Finder" dropdowns to reflect this scope. I am at a loss for how to do this.
I already tried resetting the recordsouce and applying the filtered
statement and nothing I've come up with works.

Does anyone have a suggestion of how to accomplish this?

Buttons let the user describe a filter.
I need to re-scope the cbos to reflect the newly described filter (ie region
= 120 and distrcit = 02)
When my debug code prints the filter it says "Lookup_*" plus something.

I can parse this out using Replace() and that's trivial but I'm wondering
what the hell Access is doing behind the scenes that I don't comprehend.

TIA,
Arthur



More information about the AccessD mailing list