I was wondering if anyone could help me with the following problem I need to fix.
In my database, I have a table which holds the details of members (names, username, password etc) and another table to store their responses to a series of statements I wish for them to answer (numerical raking system)
In order to gain access to the form to input their responses, they must correctly enter their details into a username and password form. The code for identify and verify access is located below:
Private Sub btnSearch_Click()
Dim sUser As String
Dim sPassword As String
sUser = Me.txtUserName
sPassword = Me.txtPassword
If DCount("*", "T_User_Details", "Username = " & sUserID & " And Password = '" & sPassword & "'") = 0 Then
MsgBox "Incorrect User Details! Please re-enter your details", vbExclamation, ""
Else
DoCmd.OpenForm "F_User_Details"
End If
End Sub
However, I want the user’s details to appear on the response form so that they do not need to enter their names etc, just simply input their numerical ranking to each of the statements.
Can anyone help me with this as it is driving me mad?