Query criteria tied to letters in Form pulldown

[gg80]

I am using Access 2007. I have a form that has a query as its source. I would like query criteria for the FleetDescription field to change when a pull down is changed on the form. If the pull down selects “Non”, I would like the query to select records where the FleetDescription field contains the letters “Non” . If pull down does not pick “Non”, then select records where the FleetDescription field does not contain “Non”

Any help much much appreciated. I just can’t seem to make this happen

[June7]

Dynamically build criteria and apply to form or report filter. Review http://allenbrowne.com/ser-62.html

[gg80]

Dynamically build criteria and apply to form or report filter. Review http://allenbrowne.com/ser-62.html

Thanks for quick reply. I have checked the AllenBrowne data before and it is very good. However it doesn't show me how to change the criteria depending on the contents of a field in the form. Because of other functions on the form the query mod would be the most convenient way. Am I trying to do something that isn't possible?

[June7]

Not sure I understand your comment. Build criteria using field or control name and apply to form Filter property. Allen Browne code is perfectly appropriate.

Is this "pulldown" an UNBOUND combobox?

If you want to provide db for analysis, follow instructions at bottom of my post.

[gg80]

Sorry I haven't replied sooner, but have some things going on that take me away from Access. I will go over Allen Browne again and get back to you. Much appreciate your help

[gg80]

I went over the Allen Browne example again found it easier to reach my goal with his VBA modified to fit my needs. Thanks very much for quick reply and referring me to try Allen Browne again.