D
DubboPete
Hi all,
Have tried variations on this, but keep getting Error 2428. Anyone know
what's wrong with these lines of code, and why I get error 2428?
I'm trying to compare the password for a UserID (stored in TblUsers) to a
text string they enter in field [text4].
<snip>
Dim StrPwd As String
StrPwd = DLookup("password", TblUsers, "[UserID] =
[Forms]![FrmLogin]![Combo0]")
If Me.Text4 = StrPwd Then
DoCmd.OpenForm "FrmBOMCreate"
Else
et cetera, et cetera, et cetera......
</snip>
Combo0 returns a numeric value, to try and match to [tblusers].[userid].
Password field in TblUsers is text.
Hmmmm....
17th Century Goat-Herder
Have tried variations on this, but keep getting Error 2428. Anyone know
what's wrong with these lines of code, and why I get error 2428?
I'm trying to compare the password for a UserID (stored in TblUsers) to a
text string they enter in field [text4].
<snip>
Dim StrPwd As String
StrPwd = DLookup("password", TblUsers, "[UserID] =
[Forms]![FrmLogin]![Combo0]")
If Me.Text4 = StrPwd Then
DoCmd.OpenForm "FrmBOMCreate"
Else
et cetera, et cetera, et cetera......
</snip>
Combo0 returns a numeric value, to try and match to [tblusers].[userid].
Password field in TblUsers is text.
Hmmmm....
17th Century Goat-Herder