Textbox Case Sensitive

[cbrsix]

@John_G - I know..I had to remove the [tblUsers.Password] because when that was in, it came back with a runtime error (see attachment Capture) then when I went to view the code it highlighted the strcomp() line. When I remove [tblUsers.Password] it comes back always wrong.

[Rawb]

lol yeah, I caught that right after I posted. That's why I changed my post to mention "Password" :P

[Rawb]

When you're referencing a Recordset field, you need to use a different format than you do in a straight SQL Query.

Dim rst as DAO.Recordset ' Created a VBA Object to hold your Query Results
Set rst = CurrentDb().OpenRecordset("<Include SQL Query Here>", dbOpenSnapshot) ' Runs your SQL Query and loads the results in to your VBA Object

At this point, things differ depending on how many Records your Query can return. . .

If you're sure the Query will only return a single Record, then you can use the following code to check against it:

If StrComp(rst("<Insert Field Name Here>"), Me!txtPassword, 0) = 0 Then
  ' Do your stuff
Else
  ' Do your stuff
End If

If there could be multiple Records in the Query results, then you'll need to search for the one you want first

Dim strCriteria as String ' the String that'll hold our search criteria

strCriteria = "[<Insert Field Name Here>]='" & <WhatYou'reLookingFor> & "'"
rst.FindFirst strCriteria ' Find the first Record that matches your search. If the search doesn't find anything, then rst.NoMatch will equal True

'Always check for rst.NoMatch!
If rst.NoMatch = True Then
  ' No matching Record was found!
Else
  ' We found a matching Record, do your StrComp() check!
  If StrComp(rst("<Insert Field Name Here>"), Me!txtPassword, 0) = 0 Then
    ' Do your stuff
  Else
    ' Do your stuff
  End If
End If

[John_G]

The syntax of [tblUsers.Password] isn't right - it should be [tblUsers].[Password]

Easier, though, is to use DLookup:

Password = DLookup("Password","tblUsers","Username = '" & txtusername & "'")

Change Username to the correct field name in tblUsers if necessary.

John

[cbrsix]

Thanks for both of your guys' help. The dlookup() seems to be working exactly how I want it to so far. I am still curious as to why the original code in my sample db would work fine but when I put it in my other db, it gave me all these problems. Any ideas as to why this would be, for my future reference..?