Passing combobox value from one form to another

[usmcgrunt]

I have a login form that appears when the user opens the database. The user selects his/her name from a combobox (I am using a SELECT stmt for the row source to pull userID, userName, and userAccess from a table) and then enters their password. Next they click an 'enter' button that verifies their username and password as well as their database access rights.



While this verification is taking place I have a splash screen that pops up that shows the progress of the verification.

What I am trying to do.

1. Hide the login form on the same 'enter' button.
2. Reference the username combobox on the hidden form in a text box on the visible splash screen form.
3. Finally, use the information in the hidden form to restrict the users access to certain forms and reports. Essentially what I am looking to do here is place an IF stmt in the form or reports onOpen event that checks the users access code in the hidden frmLogin and if it is corrent THEN open the form IF NOT then display a message stating that they do not have access to this form/report.

I am not trying to implement a security policy. I just want to limit certain forms and reports to individuals that need to access them.

Thanks for the help.

Sean

[HiTechCoach]

Sean,

What you are doing is actually "trying to implement a security policy."

1) Are you getting the log on form hidden?

Me.Visible = False

2) you will need to add hidden text box controls on the login form that hold the User name and userAccess. I assume the the combo box is bound to the user ID.

To get the data into this texct boxes you can pull the data from the columns of the combo box.

For example if the uuser Acess in in column 3 of the row source of the combo box then uset the control source of a text box to be:

=cboUser.Column(2)

Not that the index is 2. Since the first column has an index of 0.

to get the values from these these boxes on another forms use something like this:

forms!frmLogOnFormName!txtuserAccessLevel

You will need to substitute your actual form name (frmLogOnFormName) and control name (txtuserAccessLevel).

[NoellaG]

Hi,

in a similar case I used a table tsysCurrentUser. When the user logged on, the values in that table (user ID, user name, logon name, logon date/time, security level, ...) got overwritten with those of the current user. this table always contains just one record.
Two advantages: you don't have to keep a hidden form open all the time so you free some resources and you can use that table to link to the source tables of your form, making the security level part of the dataset. This made enabling security easier for me.

grNG