How to return value from table to textbox in form?

[cindytan]

I am creating a forgot password form, where the users have to enter the correct login id, secret question and answer in order to return their password.

tblUsers fields:
Login ID
Password
Secret Question
Secret Answer

Forgot password form consist of textbox and a command button:

login id [loginID_Text]


secret question [SecretQ_Text]
secret answer [SecretA_Text]
password [Pass_Text]
ok [ok_combo]

Under the [Pass_Text], i included an expression in the control source to return the password as follows:

[loginID_Text] & [SecretQ_Text] & [SecretA_Text]=DLookUp("[tblUsers]![Password]","tblUsers","Forms![Forgot Password]![loginID_Text]=[tblUsers]![Login ID]" And " [SecretQ_Text]=[tblUsers]![Secret Question]" And " [SecretA_Text]=[tblUsers]![Secret Answer]")

However, this does not work. Can anyone help on this? or any other way that i can return the password by using only macro (no VBA).

Thanks all in advance.

[jzwp11]

The control should only have the DLookup().

Assuming that all of your fields in tblUsers are text datatypes, the Dlookup() would look like this

=DLookUp("[Password]","tblUsers","[Login ID]='" & [loginID_Text] & "' [Secret Question]= '" & [SecretQ_Text] & " AND [Secret Answer]='" & [SecretA_Text] & "'")

[cindytan]

hi,

i copied and paste your dlookup into the password [Pass_Text] but it show me #Error in the textbox of form view.

[jzwp11]

I forgot a single quote; please try this:

=DLookUp("password","tblUsers","[Login ID]='" & [loginID_Text] & "' AND [Secret Question]='" & [SecretQ_Text] & "' AND [Secret Answer]='" & [SecretA_Text] & "'")

[cindytan]

thanks it works now.
But can i check with you, if i want the user to press the ok button then the [Pass_Text] will show the password instead. What am i suppose to do?

[jzwp11]

What you can do is when the form loads, hide the password control & when the user clicks the button show it (which will reveal the password).

To do this you will have to create a macro for the on load event of the form. You will need to set the visible property of the password text box control to false. Then for the on click event of the command but change the visible property of the password text box control to true.

[cindytan]

I have change the password text box control visible to No, did i change at the right place? and what macro should i set on the command button?

[jzwp11]

You have to change the visible property of the password textbox control dynamically.

As I said in my earlier post you will need 2 macros.

The first to hide the control has to be in the On Load event of the form. That way when you open the form the control is not visible.

The second macro has to be in the On Click event of the command button to reveal the control

[cindytan]

sorry, i mean which actions of the macro should be used for the 2 macro? I am new to the macro actions...

[jzwp11]

The action is SetProperty for both macros.

[cindytan]

Thanks so much for your help

[jzwp11]

I use code rather than macros, so I don't know if a macro would be capable of handling what you describe.

What I have seen before is to have a hidden control on the form and then when someone clicks the command button after entering their password, increment the control by 1 if the password is incorrect. After the control is incremented you will have to check to see if it is 3. If it is, you would close the database to prevent further attempts. The user would have to reopen the database and try again.

[cindytan]

do you know which macro action should i use?

[June7]

New thread on new topic https://www.accessforums.net/access/...ers-21650.html