VBA when clicking on record

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

Attached Files

TESTdatabase_vba_bij_dubbelklik.accdb (644.0 KB)

VBA when clicking on record