I have a form that has a drop down combo box field that I use to select an airplane type. That selection (just 1 as I don't allow you to select more than 1) then is used to compare to a table that was imported from another source. The query works when there is only 1 item in the field [FleetType] but when there is more than 1 FleetType I tried using a wildcard. See below for example of what works, doesn't work.
Field [FleetType] Values record 1 = A319;#A320;#A321;#B737;#B757;#B767
record 2 = A319
In the criteria if I use "A319" it returns 1 value --> record 2 which is correct and expected
In the criteria if I use LIKE "*A319*" it returns 2 values --> records 1 and 2 which is correct and expected
BUT if the criteria I use is [Forms]![NewSearch]![cboFleetType] AND I only select A319 I get 1 record --> record 2 which is what is expected HOWEVER, I want to include all records that have A319 as one of the fleet types SO....
in respect to the 2nd situation above I use criteria LIKE "*[Forms]![NewSearch]![cboFleetType]*" and I get nothing....
Why doesn't the wild card using the form value/reference not work? I even built a new field on the form that is a copy of what is selected from the combo drop down to "get the value away from the cbo field" and to confirm what value was being selected and that also doesn't work.
HELP PLEASE