Combo Box > form update - should be easy !!?!?

[PhilipEwen]

I have a form which is attached to 2 tables, manufacturers & products.
Products has a ManufacturerID field ( relates to Manufacturers.ManufID )
and also has things like product name etc etc.
Manufacturers has ManufID and ManufacturerName

What i want to do is to have a combo box that gives a list of manufacturers. AfterUpdate of the box, a list box is propogated with all the products from that manufacturer.

I keep going in circles with Me.Refreshes, Select Rowsources etc etc.
Can someone provide a step by step way of doing this PLEASE !

Thanks.

 

[Robert Saye]

What you want is a cascading combo box. Steo one is for your list box, create it as unbound. Set the row source type property as table/query. Set the Row Source by clicking ... next to it. This will bring up the query design view. Select your products table, for your fields select Product Name (Plus any other fields like Product description), and ManufacturerID, for criteria under the ManufacturerID put [forms]![YourFormName]![ControlNameWhereTheySelectedTheManufacturer (combobox1 etc..)]

This looks kind of confusing but it is pretty simple.


HTH Robert

 

[PhilipEwen]

Thanks for the help...it still doesn't work, it just comes up with blank !!???