I have 3 combo boxes and I would like them to interact as follows:
Equipment Type - (e.g. PC, laptop)
Regular Drop Down
Supplier - (e.g. Dell, Toshiba)
Shows only suppliers of selected Equipment Type
Model - (e.g. GX270, 2410-703)
Shows only models of selected Supplier AND Equipment Type
I have got the suppliers' dropdown limited to equipment type and the model dropdown limited to supplier (see code below).
select dbo_model.id, dbo_model.supplier_id, dbo_model.equipment_type_id, dbo_model.model
from dbo_model
where (((dbo_model.supplier_id) in (select supplier_id from dbo_hardware)));
But as Dell (as e.g.) make more than one equip_type I need the model dropdown to be filtered by both the supplier and equipment_type.
select dbo_model.id, dbo_model.supplier_id, dbo_model.equipment_type_id, dbo_model.model
from dbo_model
where (((dbo_model.supplier_id) in (select supplier_id from dbo_hardware))) AND (((dbo_model.equipment_id) in (select equipment_id from dbo_hardware)));
When I use the code above, access crashes when I try to enter Form View giving an error with my "msjet40.dll" I have all the availble service packs from M$ and the latest version of Jet.
Is it a coding error, and access error or an OS error?
Hope you can help!
Equipment Type - (e.g. PC, laptop)
Regular Drop Down
Supplier - (e.g. Dell, Toshiba)
Shows only suppliers of selected Equipment Type
Model - (e.g. GX270, 2410-703)
Shows only models of selected Supplier AND Equipment Type
I have got the suppliers' dropdown limited to equipment type and the model dropdown limited to supplier (see code below).
select dbo_model.id, dbo_model.supplier_id, dbo_model.equipment_type_id, dbo_model.model
from dbo_model
where (((dbo_model.supplier_id) in (select supplier_id from dbo_hardware)));
But as Dell (as e.g.) make more than one equip_type I need the model dropdown to be filtered by both the supplier and equipment_type.
select dbo_model.id, dbo_model.supplier_id, dbo_model.equipment_type_id, dbo_model.model
from dbo_model
where (((dbo_model.supplier_id) in (select supplier_id from dbo_hardware))) AND (((dbo_model.equipment_id) in (select equipment_id from dbo_hardware)));
When I use the code above, access crashes when I try to enter Form View giving an error with my "msjet40.dll" I have all the availble service packs from M$ and the latest version of Jet.
Is it a coding error, and access error or an OS error?
Hope you can help!