0

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...

2
Contributors
1
Reply
2
Views
10 Years
Discussion Span
Last Post by shasur
0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.