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

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

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.