LOGIN with designated branch!

[Downie]

The below code is working:

Existing TABLE:
id
Login
Passowrd

If Not IsNull(DLookup("[Login]", "users", "[Login] = '" & Me.Login & "'
AND [Password] = '" & Me.Password & "'")) Then
DoCmd.Close
DoCmd.OpenForm

Else
MsgBox "InValid Login"

End If

End Sub

However, I added a new column to the users table called start form.
The need for this column is so that we can direct different users to
different FORMS on login.

New TABLE
id
Login
Passowrd
start_form (new column)

Any suggestions on how to incorporate this functionality???

 

[Guest]

off-the-cuff; add an If Then for the open doc command that is dependent upon
the value in that new column.....