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)

 

[RuralGuy]

I will assume you "display all the printer cartridges made by that manufacturer" in a SubForm on your main form with the ComboBox. The MainForm should be bound to the "printer manufacturer" query/table and there should be a PrimaryKey in that table that is also a ForeignKey in the "printer cartridges" table. An AutoNumber works best here. It is these two fields that you whould use for the LinkChild/MasterFields of your SubFormControl. Post back if you want more step-by-step directions.