DLookUp

[DS]

I'm trying to grab the TerminalID through Environ but it doesn't seem to
be grabbing it. Any help appreciated.
Thanks
DS

Me.TxtTerm = DLookup("[TerminalID]", "tblInfoItem", "TerminalID = Environ")

 

[Duane Hookom]

If you are looking for the name of the PC, check the API at
http://www.mvps.org/access/api/api0009.htm.
Me.TxtTerm = DLookup("[TerminalID]", "tblInfoItem", "TerminalID = '" &
fOSMachineName() &"'")

I don't think Environ variables are always reliable but they are call as a
function with an argument.