Capturing Global variable values

[Larry06Green]

How do I write global variable values to a table. I have the following module
which captures the network user id and computername when they log into my
database.

Option Compare Database
Global racf As String
Global wkstation As String

Function GetName()
racf = Environ("username")
wkstation = Environ("computername")
End Function

 

[AkAlan via AccessMonster.com]

This depends on whether you are updating the table or appending it. If you
are updating the try a sql UPDATE command and if you are appending the table
try an INSERT INTO command.