DLookup only returning first value from table

[Mohamed]

Hi



I wonder if someone could help.

I am using a DLookup function on a command button to populate a field on a form with value from another table. However it only seems to populate the field with the top value from the table.

Below is the code

Private Sub Command111_Click()
Me.lngEncrpytion_Password = DLookup("[Password]", "[tblpasswords]", "EncryptionID = EncryptionID = '" < myknowngoodpassword > "'")
End Sub

Any help will be much appreciated.

Thanks

[Toyman]

Hi

I wonder if someone could help.

I am using a DLookup function on a command button to populate a field on a form with value from another table. However it only seems to populate the field with the top value from the table.

Below is the code

Private Sub Command111_Click()
Me.lngEncrpytion_Password = DLookup("[Password]", "[tblpasswords]", "EncryptionID = EncryptionID = '" < myknowngoodpassword > "'")
End Sub

Any help will be much appreciated.

Thanks

DLookUp only returns on record at a time. If you don't place criteria in the funtion it will return the fist record in the table. In order to get the record you are looking for, you must put in combination of criterias.