me.name (1 Viewer)

[eMel]

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 I reply to the replies below???

 

[GinaWhipp]

Try...

Screen.ActiveForm.Name

 

[KenHigg]

me.Form.Name

 

[Cronk]

Use
"Insert into Table1 (Formname) select '" & Me.Name & "'"
if the code is executed in the form being opened.

Alternatively, use Gina's construct, but in the same format above, if from somewhere else.