Hello all,


After reading quite a few solutions that seemed to be the fix i needed i have been unable to solve my own problem. Hopefully by attaching my db to this thread someone smarter than myself can lead me to the right road.

I have frm_workorder with a subform_workorder_detail which is linked parent/child with WorkorderID.
In frm_workorder i have a field VariantID (it is from the tbl_vehicle_Issue) and is autopopulated when the VehicleID is selected to start a new Workorder.
The subform_workorder_detail has a field RetrofitKitID which i am trying to filter based on the VariantID once the VehicleID is selected in the main form. When i use the drop down in the RetrofitKitID i can see all kits available and can see the variants, but i only want to see the specific variants applicable to that variant identified in the main form.

I surely would appreciate someone taking a look and see what i have not been able to figure out. Thanks