Filtering with Cascading Combo Boxes

[Guest]

When using a form to create or update a record my cascading combo boxes work
beautifully. However, I want to filter by form using the same cascading
combo boxes. Can someone point the way?

 

[AlCamp]

Marguerite,
You can't use the same combo fields on your form to enter data into
fields in your table, and... also use them for filtering.

Filtering this way would mean changing the combo values of an actual
record to accomplish the filtering you want, then having to put the original
values back the way they were before you began filtering, so that the record
combo data is still correct.

What you're trying to do is really what "filter by form" is meant to do.

hth
Al Camp

 

[Guest]

Thanks for the quick response. I now understand the flaw in my "logic."