Dlookup function syntax error 1

[vandaliarental]

I am trying to set a variable to a value found in another table & am getting a syntax error on [CID]='605050'.

Here's the statement:
Dim str as string
str= DLookup("[group_desc]", "TestTaxExempt", "[CID]='605050';&quot

I've checked the TestTaxExempt table & there is a valid string in the [group_desc] field for CID = 605050.

I've also checked the references library & DAO 3.6 Library is checked (along with visual basic for applications; MS Access 9.0 object library; OLE automation & MS ActiveX Data Objects 2.1 library).

Any help would be appreciated.

Thanks,
Connie

 

[Norris68]

Remove the semi-colon. It's added to the end of queries by Access for no apparent reason - it's not part of SQL syntax.

 

[vandaliarental]

Thanks, Norris68! I figured it was something incredibly simple!