Filling a text box or combo

[train.fan#007]

Hi Guys & Girls,

I am puzzling over this problem:-

On a Form, I have combobox1 filled with manufacturers names, from a table.

I wish to fill textbox1 or combobox2 with all the different models from
each manufacturer, either through a table or query.

Example:- If combbox1 has "Ford" selected, I would like the textBox1 or
ComboBox2 to list all the Ford Models.


Then subform1 with all available parts for each manufacturer, from various
querys.

Example:- As above, then shows all available parts from the 'Ford' Stock
List.


At the moment I have tables & querys as follows:-
tblOptionMakers,
tblOptionModels,
tblStockList.
qryAllModels,
qryAllStockList,
qry(ManufacturersModels)List,
qry(ManufacturerStock)List,


I have no extra coding as yet, all advice is greatfully received.

TIA

Lindsay.

 

[train.fan#007]

Thanks very much Dave,
I will try your answer tomorrow.

Thanks again
Lindsay.