Password in a table

[samotek]

Can you help me build a password that is written in the table “my company information” field PIN
I want at first to write the password by opening the form containig this table, and after that, with the help of what is written there pass it to the variable strPassword ?
As in :
Dim strPassword As String
strPassword = InputBox("Please enter the password")
If strPassword = "pin" Then

 

[Remou]

Do you mean DLookUp?

[tt]If Nz(DlookUp("pin","my company information","pin='" & strPassword & "'"),0)>0 Then
'pin is correct[/tt]