Using a combo box to display a table

[Gamezy]

I'd like to be able to select a choice of printer manufacturer(as a combo box), which will then display all the printer cartridges made by that manufacturer in a table below the combo box. I have made the forms (with the relevent combo box looking up manufacturers) but am now sure how to relate the two so that the table updates, depending on which manufacturer is selected. Again this seems like a simple problem but I am new to access and sitll working my way around the program.

(Yes, I have tried goodle, but I can't seem to find quite what I'm looking for)

 

[Gamezy]

Ok, cancel this, I found a way to do it, took me a while but seems that it's possible by using the wizard, I was just going about it the wrong way. thanks anyway.

 

[valheru]

Hi Gamezy

Attached is a file in which I have used some code to demonstrate one of the ways of achieving this.

Regards

 

[valheru]

Okie dokie, the example uses two combo boxes, didn't see the table bit. Glad you found your answer.

Enjoy