Not equal to question

[jneirinckx]

Good afternoon,
I have a form where I enter criteria that a query pulls from and then runs a report. The user can pick from a combo box which "codes" to filter on including an "*" for all codes which all works fine. I have been asked to have an option to include all codes except the one they choose . ie <> "a".

I am struggling on how to accomplish this through a combo box selection.

Appreciate any ides you might have.

Thanks
Jerry

 

[PNGBill]

If your combo box was a value list and the selected data used in a Select Case vba statement to run the approriate sql.

Use the AfterUpdate event to read the form control (combobox), run appropriate sql and open what ever (subform, report...)

 

[jneirinckx]

Thank you for your replys.
I do need to use the query as there are also other fields and calculated fields used in the report.
I try to make it easy for the user to enter the criteria through the form which works well. But again struggling on how I could have the user pick a code option to excluded it from the report. If it was just in the query i would put in the criteria <> CA . So trying to accomplish that from the form.

Thanks again.
Jerry

 

[jneirinckx]

Thanks again. Sorry I miss understood.

So where would I put your code ?

J