Recordset help

[pepps]

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

[RichardODreamweaver]

Are you doing this from an Access database via an ODBC connection? Or is this just an Access question?

[pepps]

Hi i am doing this via an ODBC connection

Thanks

John