Access DLookUp using variable

Question

I cannot seem to get the following code to run. I appear to be having an issue with using sHostName in my Dlookup statement. What am I doing wrong?

Dim sHostName, LNum As String
sHostName = Environ$("computername")
LNum = DLookup("LineNumber", "tblLineNumber", "ComputerName = sHostName")

Does this answer your question? [MS Access DLookUp using variables](https://stackoverflow.com/questions/19493863/ms-access-dlookup-using-variables) — Warcupine, Jun 14 '21 at 14:45
Note that `sHostName` has not been declared as a string, but rather a variant - you need to implicitly state the type = `Dim sHostName As String, LNum As String`, — Applecore, Jun 14 '21 at 14:58

score 0 · Accepted Answer · answered Jun 14 '21 at 14:46

0

You need to concatenate the value of the sHostName variable.

DLookup("LineNumber", "tblLineNumber", "ComputerName = '" & sHostName & "'")

answered Jun 14 '21 at 14:46

Kostas K.

Now I get a Run-time error '94' Invalid use of null – Thomas Heikkila Jun 14 '21 at 15:00
See this on how to properly handle the `DLookup()`: https://stackoverflow.com/questions/67720613/access-dlookup-runtime-94-error-invalid-use-of-null/67723044#67723044 – Kostas K. Jun 14 '21 at 15:03

1 Answers1