I hope this is the correct forum to post this.

Wondering if anyone could help...


On a form a continuous record list is displayed as results of running a QUERY.

While this QUERY is displayed, I’d like to filter it.

QUERY would display on a FORM showing: (customer: being the field name and jobdate: being the other field name) Well, control source since it's on a form?

customer jobdate

acne 1/1/07
acne 1/2/07
ace 1/3/07
acne 1/4/07
ace 1/4/07

On this form, a combo box will display the choices ACNE and ALL
From this FORM the QUERY is displayed on, I'd like to FILTER the form to toggle between showing ALL (as listed above) and JUST showing ACNE - without closing the form.

customer jobdate

acne 1/1/07
acne 1/2/07
acne 1/4/07

I have a combo box on the form that gives me 2 options to filter...either display ALL records the QUERY displayed originally or just show me records of customer “ACNE”

I'm hoping someone could provide the code I can place in the AfterUpdate (or AfterChange) portion...

You can use the filter function to get the 'acne' array alone

' If you have the existing contents in arOriginal then

arFiltered = Filter(arOriginal, "acne")

should give you the results containing 'acne' alone in arFiltered array

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.