Passing parameters into subqueries

[krop]

INSERT INTO model ( model, supplier_id, equipment_type_id )
SELECT ([Please enter new Model:]), hardware.supplier_id, hardware.equipment_type_id
FROM hardware;

Hi, hope you can help. I've looked on the net but can't find understand anything relevant.

In my main form the user selects a equipment type from a drop down and then a supplier from a dropdown. The third dropdown (model) is filtered by the responses to the other two dropdowns but if the model does not exist is has to be created. I have a append query button on the form which prompts the user to input the new model name and then SHOULD insert that name and the supplier_id and equipment_type_id into the model table. However, it adds one line for each item of hardware rather than just the one I was editing in the main form.

How do I get access to pass this value to the subquery? I thought it would do it automatically.

Thanks in anticipation,

Krop

 

[krop]

Have done it now by using:

INSERT INTO model ( model, supplier_id, equipment_type_id )
VALUES (([Please enter new Model:]), (forms!myHardwareForm!cbo_Equipment_ID), (forms!myHardwareForm!cbo_Supplier_ID);

Thanks for stopping by though...