Hi,
I had a very similar problem but managed to solve it. in my tables on top of the autonumber userID field i had Login (text filed). I simply changed:
"[userID]='" & Me.txtUser.Value & "'"
to
"[Login]='" & Me.txtUser.Value & "'"
and it worked beautifully :)