Log the date in a different table when record is displayed

[David*DJ]

Hello everyone,

I just need a little help with this one. I have a fairly large table which holds our season ticket holder records, when the visitor arrives we enter the ticket number into a simple form and up pops their picture. How can I log the date and time they have arrived into another table as soon as the picture appears which will allow me to report on how many times they have visited, when etc? For info I have very little VB experience - MACRO's were the only thing around my in day!

PS I have checked under audit logs but they all seem to relate to record changes and I need the logging only when the record is displayed.

Many thanks in advance.

David

 

[jeremypaule]

you can add text boxes that contain the current date and time on the form and when you access that person you can make some type of append query to append date and time

 

[boblarson]

So, I would say the On Current event of the form would be the appropriate event to place the code to populate the audit table.