Table name substitution in DLookup

[GraeagleBill]

I can't seem to hit on the appropriate syntax wherein I can substitute a string variable containing the name of a table. E.g., strTBLName = tblRegister. I've tried the assortment of statements below without success. It would be hard to believe, but maybe such substitutions aren't supported in the VBA language set?

curAcBal = DLookup("[CurBal]", strTBLName , "[Acctid] =" & AcID)

curAcBal = DLookup("[CurBal]", "strTBLName", "[Acctid] =" & AcID)

curAcBal = DLookup("[CurBal]", " & strTBLName & ", "[Acctid] =" & AcID)

[Micron]

Maybe you need to wrap your string variable in quotes and probably brackets (I'd try single quotes first)
DLookup("[CurBal]", & "'[" & strTBLName & "]'" , "[Acctid] =" & AcID)

[GraeagleBill]

strTBLName was set to the wrong string name which obscured the real problem.

As a string,
curAcBal = DLookup("[CurBal]", strTBLName , "[Acctid] =" & AcID)

works as expected.

[ssanfu]

This syntax worked for me

curAcBal = DLookup("[CurBal]", strTBLName , "[Acctid] =" & AcID)

Test Code

Sub Dlookuptest()
    Dim tmpString As String
    Dim strTBLName As String

    strTBLName = "MyData"

    ' DLookup returns a text string
    tmpString = DLookup("[competitor]", strTBLName, "[rank] =" & Me.rank)
    MsgBox tmpString
End Sub

late again!!