Filter Query Based on Form Field (1 Viewer)

kobiashi said:

H

I am trying to filter a query i have set up in a combo box, based on a form field.

so the table is

Vehicle_ID | VehicleNumber | VehicleType
1 | V001 | B92
2 | V002 | B92
3 | V123 | B2007

on the form there is 4 combo boxes - form name (NewMCUTracker)

VehicleAtFault
Vehicle1
Vehicle2
Vehicle3
VehicleType

what i am trying to do is, filter Vehicle1, Vehicle2, Vehicle3, based on VehicleAtFault selection

i thought i could filter the query in the combo box by adding VehicleType to the query and inserting in the criteria

Code:Copy to clipboard

[form]![NewMCUTracker]![VehicleType]

but it doesnt work

is there something im doing wrong

Click to expand...