Opening two forms at the same time (Access 97 SR-2)

Topic

New Reply

I have a password security system that others in the office helped develop that is in VBA. The log-in form contains a user name and password with an option group that opens different forms for data entry. It works great. The password is checked and only allows users that are assigned certain records access to those records.

What I would like to do is to have the log-in form open every time a user opens any form and set the permissions for access to their records. I added the log-in form to the OnActivate event on a test form. Both forms opened but the log-in form is behind the data entry form and is not visible.

What I would like to do is get rid of the option group on the log-in form, have the log-in form to open first when a particular data entry form is called, get filled in, and then open the data entry form with the proper permissions. Can this be done? TIA.

Reply | Quote

Replies

You can have the log-in form open as a pop-up, which will cause it to remain on top until the user logs in and clicks okay. I have another idea you might want to try: Why not get rid of the option group, but only have the user log-in once? When they log-in and click okay, pass some value from the log-in form to a menu form. The menu form can contain command buttons to your various forms. Code behind the buttons will open the appropriate form using the log-in value to determine which records the user may view. Let the menu form remain open, so that whenever a form is closed, the user again sees the menu and can choose another form or close the database.

Reply | Quote