DLookup Syntax Error

[uncletreetrunk]

Hi all,

I don't what's giving me error 3075. Syntax Error

Public Function IsInTable(tblName As String) As Boolean
If Me.ProgNum.Value = DLookup("Program Number", tblName, "[Program Number] = " & Forms!Add!ProgNum) Then

And I call IsInTable

If IsInTable("Historical") = False Then 
Exit Sub

I followed this link that pbaldy provided to me earlier
http://access.mvps.org/access/general/gen0018.htm



I'm sure it's simple but I can't seem to find it....

Thanks for your help!

[uncletreetrunk]

Oh and Program Number is a general number field in the table, I've double checked

[John_G]

Hi -

Your Dlookup needs to look like this:

DLookup("[Program Number]", tblName, "[Program Number] = " & Forms!Add!ProgNum)

with the first "Program Number" in square brackets as well, even though it is in quotes.

If any of your table names contain spaces, they will cause trouble as well, so you could use the DLookup like this:

DLookup("[Program Number]", "[" & tblName & "]", "[Program Number] = " & Forms!Add!ProgNum)

HTH

John

[uncletreetrunk]

Thanks for you help John! I know the spaces aren't according to naming convention, but I learned after I had setup most of this database :P

[John_G]

Glad I could help.

I tend to use spaces myself (and, yes, I know they're frowned on!); I just have to remember to use the square brackets all the time.