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