Several questions with Access 2016

Question

Hello  –

I am in the process of setting up user logins for an Access 2016 database. The article that I am using
to accomplish this task is the following:

https://www.datanumen.com/blogs/how-to-protect-your-sensitive-data-with-a-login-form-in-access/

Following the procedure shown in the article, I have created a login table, and associated form that I would like to deploy.
However, I am running into two issues:

1. The Cancel button on the login form does not work, and although I have the code,
   every time it is applied, it overwrites the code for the Login button on the same form.
2. I would like to have the login form be the first form that is seen by a given user. After
   the user logs in, I would like them to be automatically brought to another form.

How can this be done?

Answer 1

Access is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access
https://social.msdn.microsoft.com/Forums/en-US/home?forum=accessdev

--please don't forget to Accept as answer if the reply is helpful--