Hi,
I am creating a database which will allow users to enter a numerical response to a series of statements.
This form will have the users name and department located on it automatically once the user has logged in.
I have create a table containing the user details e.g. username, password, name and department.
I have another table which will hold the returned values for each statement the user must rank.
In addition to this, I have a user verification form, which check the user's username and password correctly, and will only open the response form once their details have been verified. The code form this is shown below:
Private Sub btn_Search_Click()
Dim sUser As String
Dim sPassword As String
sUser = Me.txtUserName
sPassword = Me.txtPassword
If DCount("*", "T_User_Information", "UserName = '" & sUser & "' And Password = '" & sPassword & "'") = 0 Then
MsgBox "Incorrect User Details! Please re-enter your username and password", vbExclamation, ""
Else
DoCmd.OpenForm "Navigation Form1"
End If
End Sub
The problem I am having at the moment is that once a user has been verified, the form brings back the details for the user, regardless of the user’s details which have been entered.
Can anyone help suggest a way I can get the response form to link up with each user?