Dlookup problem on a logon form

[redfox]

This is probably a simple and dumb question, but I am new (be gentle )



I have the following code

'Check value of password in tblEmployees to see if this matches value chosen in combo box
 
    If Me.txtPassword.Value = DLookup("strEmpPassword", "tblEmployees", "[lngEmpID]=" & Me.cboEmployee.Value) Then
 
        lngMyEmpID = Me.cboEmployee.Value
 

It works just fine. The problem I have is instead of getting the Employee's name (or number) from a combo box I want to get the same info from the form but from a text box.


On one of my attempts I created a text box named txtEmployee and changed the cbo in the above code to txt. I get various errors as I try different things I have looked and done some searching online and can not find an answer that I understand or can adapt to my code. I am new to VBA and wanting to learn more.

If you can help I would really apericate it

[PEB]

HI

In your code obviously you want to use text /string/ as a value when you search the password...

IN VB the text is marked with " or '

So your code:

'Check value of password in tblEmployees to see if this matches value chosen in combo box
 
    If Me!txtPassword = DLookup("strEmpPassword", "tblEmployees", "[lngEmpID]='" & Me!cboEmployee+"'") Then
 
        lngMyEmpID = Me!cboEmployee
 

IF your Me!cboEmployee is a number so:

'Check value of password in tblEmployees to see if this matches value chosen in combo box
 
    If Me!txtPassword = DLookup("strEmpPassword", "tblEmployees", "[lngEmpID]=" & str(Me!cboEmployee)) Then
 
        lngMyEmpID = Me!cboEmployee
 

Have a nice day

This is probably a simple and dumb question, but I am new (be gentle )



I have the following code

'Check value of password in tblEmployees to see if this matches value chosen in combo box
 
    If Me.txtPassword.Value = DLookup("strEmpPassword", "tblEmployees", "[lngEmpID]=" & Me.cboEmployee.Value) Then
 
        lngMyEmpID = Me.cboEmployee.Value
 

It works just fine. The problem I have is instead of getting the Employee's name (or number) from a combo box I want to get the same info from the form but from a text box.


On one of my attempts I created a text box named txtEmployee and changed the cbo in the above code to txt. I get various errors as I try different things I have looked and done some searching online and can not find an answer that I understand or can adapt to my code. I am new to VBA and wanting to learn more.

If you can help I would really apericate it