lundi 20 avril 2015

VBA MS ACCESS - Login form redirect to different form based on selected button

I have login form:

http://ift.tt/1yLEi7J

Each button decides what source will be used by cbUserLogin ("Nazwa" on screenshot)

CODE:

Private Sub buttonUAP1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)

    Forms!MainLoginForm!cbUserLogin.RowSourceType = "Table/Query"
    Forms!MainLoginForm!cbUserLogin.RowSource = "queryUsersUAP1"
End Sub

And for each button the same code with the different query source.

I want to do something to actually decide where user will be directed based on that button.

If while logging in UAP 1 button is selected and login and password will match i want to land user in form_UAP1, if button UAP 2 will be selected while logging in i want to make user land on form_UAP2, etc.

Im trying to bite that thing for already some days and i just can't find solution.

Aucun commentaire:

Enregistrer un commentaire