Can anyone help please?

I have to make the news page that will show some news and on the bottom of the page I would like to make some links to older news sorted by couple of different topics.
My question is how to automatically tell where will news be sorted (by topics) after I insert some new record.

If you're using an Access-database create an extra hidden field with, for example, <subTopic> in your newstable. Now think about which constant values you want to give them. After doing this create an SQL-statement in the recordset with the subtopics like this:

SELECT *
FROM rsTopics
WHERE subTopic = value
ORDER BY date ASC

Keep in mind to keep the value exact to the subtopics. The last line is just a way of sorting the items by date. Good luck!

Rein