I have 4 tables
Department, cell, assets and work Orders.
I have 1 form
Work orders
On form work orders I have 3 combo boxes
Department With the data source as; SELECT TblDepartment.IDD, TblDepartment.Dept FROM TblDepartment;
Cell combo boxes data is dependent on the Department selected SELECT FROM TblCell WHERE [Dept]=[Forms]![FrmWork_Order]![Department];
All the above works!
I would like to select the Assets that are related to the data selected in the Cell combo box
I have tried; SELECT FROM TblAssets WHERE [Cell]=[Forms]![FrmWork_Order]![Cell];
This query doesn’t return anything.
Not sure what I’m doing wrong.