Thanks all (1 Viewer)

[eMel]

Since my browsers, at work, won't reply.

I fixed the problem. Rather than using Screen.ActiveForm.Name, I omitted the fourth column for the name and changed the logon string from "Logon Open" to "Subject Candidate Form Opened". Simpler and it works.

Now to figure out how to do this with a report and then a table. Whew!! Guess y'all will be hearing from me again, soon!

Instead of: Private Sub Form_Load()
LogEvent = " Logon Open "
LogEvt
End Sub

I changed it to:

Private Sub Form_Load()
LogEvent = " Logon Subject Candidate Form "
LogEvt
End Sub

And removed the fourth column. Look for me in the report section.

 

[BlueIshDan]

Is that right... lol

 

[GinaWhipp]

Will be easier with the fourth column. Perhaps you can adapt something like this...

http://www.access-diva.com/vba10.html

While above logs field changes, you can see how it's not dependent on the Access finding the active Form. Just a thought!

In any event, see you in Reports...