Simple Combobox Proplem, for you maybe, for me? hell no!

[rich_bell20]

Hi, Could someone Please help me, My Knowledge in Ms Access is restricted, and i have next to no experience in SQL. good luck in helping me. Basically i have 2 combo boxes, one called ProductCat, which has two categories, garden and kitchen. when i click on garden, how can i make the garden items , such as, seed, turf etc, appear in the next combobox. and if i click on kitch, how do i make lights, microwave etc, appear ion it.

any help much appreciated, thankyou.

 

[browntrout]

This link (to Q289670) will show you the official Microsoft way:

http://support.microsoft.com/default.aspx?scid=kb;en-us;289670

 

[FoFa]

Are your comboboxs based of a query or a value list?

 

[rich_bell20]

They are query based, im working on this northwind example now but struggling!!

 

[rich_bell20]

I finally managed to work it out, thanks guys!