VBA when clicking on record

[WimDC]

Hello,

In a new project, I want to keep "statistics" of what records were "clicked".
(See attached database in Access2010)

Now I have a very simple form with the different records. Those records can be modified/added by the user.

Is it possible to write VBA so when a user clicks on a specified record, then:
1) VBA adds a new record to "tabel_stats" with the current date/time AND recordnumber of the choosen record
2) VBA opens the hyperlink of the choosen record.

(see explication in VBA in form "Formulier1")

Thanks a lot !!

Wim