Syntax Error in DLookup()

[Triscuit]

Compile Error
Expected: list seperator or )

On the first line.

   DLookup("usrID","tblUsers", "[txtFName] = '" &Me.txtFName& "' "_
    & "AND [txtMInitial] = '" & Me.txtMInitial & "' " _
    & "AND [txtLName] = '" & Me.txtLName & "' ")

Can anyone point this out for me?

 

[pbaldy]

The line continuation is a space and an underscore. You missed the space.

 

[Triscuit]

Thank you for the response and made the change but the same error appears.

When the compile error comes up it highlights the red part

DLookup(" usrID","tblUsers", "[txtFName] = '" &Me.txtFName& "' " _
& "AND [txtMInitial] = '" & Me.txtMInitial & "' " _
& "AND [txtLName] = '" & Me.txtLName & "' ")

 

[Triscuit]

Found the error needed spaces around the &Me.txtFName&
goes to & Me.txtFName &

 

[pbaldy]

Well, you've got what I assume is an extra space in your field name, and no spaces between the ampersands and the form reference.