password in a table

[samotek via AccessMonster.com]

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

 

[Alex Dybenko]

Hi,
you can try to use a DFirst function:

If strPassword = DFirst("Passwordfield","MyTable") Then
....

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com