I want to write my form name to a field called ItemName on a table when aform is opened/closed. Can't quite figure out me.name. Help?
SQL = "INSERT INTO EventLog ( Event, EvTime, UserName, ItemName ) SELECT '" & LogEvent & "' AS x1, #" & Now() & "# as x2, fOSUserName(), me.name;"
Why can't...