Recordset help

I have an access database which has a table of categories and a table of products, when the user clicks on the relevent category the products relating to that are listed.

is there a way so when the user clicks on a certain category the results page could be a set of tables pulling the relevant information, at the moment the results page is one table, which i would still need to keep for the results of the other categories, it is only one categorie that would need to display more than one table.

How could i do this

John