D lookup

[peterbowles]

Hi all

I have a DLookup function on form. Which if a record is matched against the value is typed in it finds the value and insertes a word in front of the value

If Me.password = [IDNumber] Then

Me.Text50 = "Hello" & DLookup("Name", "passcode", "IDNumber = '" & Me.password & "'")

Else
Me.Text50 = "Invalid Number "


End If

The problem is that it only looks at the first value in the record table

Please help

 

[edtab]

Try this:

Me.Text50 = "Hello" & DLookup("Name", "passcode", "IDNumber = " & Me.password).

edtab