Making a list only display what is relevant

[iggy450]

Hi

I have been tasked with creating an Access Database at work. I am no expert. Last time I used it was when I was at college in 2004.
Anyway, I have created a few tables and forms in which to input the data in as you do.
So I have a form which pulls up the Manufacturer of an item we use.
I would like to add a list which pulls up a list of all the products we buy from that manufacturer.
At the moment the closest I have got is when I select a Manufacturer it just lists all the products from all the manufacturers.



So As an example. If I select "Apple" then I would like it to only call up the Apple Products, so "iPad" and "iPhone 5s" etc.

Any help would be very much appreciated.

Kind Regards

Tim

[pbaldy]

Sounds like this:

Baldy-Cascading Combos

[iggy450]

Hi

Thanks for the reply.
I have actually found a easyish way of doing it.
I created a Query which used my Manufcaturer as a search field and in my query I only have my products as visible.
I added a list box which used the query as my data and saved the data into the table I have all my Assetted products. Then on my Manufacturers list box created a VBA script to do the me.refresh on click so my Product list box updated.

I hope this makes sense for anyone who potentially has the same issue

Thanks

[pbaldy]

No problem, and welcome to the site by the way.