The txtUser textbox on the Switchboard accepts the User's Initials.
(let's say ABC is the txtUser.Text)
strCurrentUser is set to that string.
The Private Function fnCheckUser() (behind the Switchboard form) breaks on the following line:
fnCurrentUser = DLookup("fldUsers", "tblUsers, "fldUsers = " & strCurrentUser)
The error message says:
The result of the query resulted in the following error: The Object does not contain the Automation Object "ABC"
and stops the program.
There are no OLE fields in this very simple DB. There is Access97 for the Program DB and the Data DB. I'm not calling a Named Query (although I suspect Access is calling the DLookup a "query")
What am I doing wrong? I think the syntax is right and the Text field "fldUser" does contain "ABC" (and all the other sets I tried)