Form Logging

[Guest]

I have a form I want to open as my first screen. I want to have one command
button on the form that will open my main entry screen. This is easy but my
question is I want a table to track each time that form is open with the
users name and date. I know how to establish this if you add new records but
I have never done it for opening a form with no records...

Thanks in advance...Jen

 

[ManningFan]

Make a new table called tblLog. In it, put a FormID field, a Username
field and a DateStamp field. Then write to the table the same way you
write to a table when there's data. The only difference is the data
will sit in a seperate table. When you need the data, use a query with
a link to the FormID to know who opened what form at what time.

 

[Guest]

Did all that but figured it out after I read your answer the problem was the
user/date had to trigger on the "Load" inorder to generate the information.

Thanks Jen