Pass data from login page to form with multiple tabs accessed via navigation control

[billperry51]

As you can likely tell when you read what I've written below, I'm quite new to VBA and pretty new to MS-Access too, so please try to go easy on me



I have a Navigation form with horizontal tabs including: 1) Login; 2) Existing User

I have a form frm_login mapped to the Login tab on the navigation form
I have a form frm_existing_user mapped to the Existing user tab on the navigation form
Tabs on frm_existing_user form include: i) Enter New Data; ii) Update Fields; iii) etc.

User logs in via the login form; upon successful login, I capture user_name. I want to pass user_name to frm_existing_user form.

The following code works perfectly except for one issue noted below:
DoCmd.OpenForm "frm_existing_user"
Forms![frm_existing_user]![user_name_tbl_transactions] = Me.txt_user_name

The problem is, this code opens frm_existing_user outside of the navigation form.

If you can see the above image, now there are two open forms: i) Navigation; ii) frm_existing_user after the code I pasted in above executes. I only want a single open form (the navigation form). From there a user can click "Existing User" on the navigation form. Then user can select the appropriate tab on frm_existing_user.

I'd like for frm_existing_user to open within the Navigation form. However, I'm struggling in my attempt to open frm_existing_user within the navigation form

Can someone please point me in the right direction?

[ranman256]

The login form need only get the user to the next form if login was successful.
hold the user ID in a global variable see in every form.
gvUserID=me.txtUser

in a module:
public gvUserID

[billperry51]

Thanks ranman256 - I created a module:

Public Function PassUserName() As String
PassUserName = Me.txt_user_name
End Function

Now for the next beginner question - from where do I invoke the code?

On a form named frm_existing_user, I have a text box with control source = user_name_tbl_transactions
On that form, I mapped =PassUserName() to user_name_tbl_transactions via the Default Value data property

That mapping is not setting user_name_tbl_transactions to the value entered into me.txt_user_name.

What am I doing wrong (or worse yet, not understanding) now?

Thanks for your help

[Micron]

What you probably don't realize is that when using a nav form, only one form is open at a time. When you choose a different tab, one form closes and another opens. It complicates things when trying to pass values from one to another. You can't code the Close event of form A to pass a value to form B because there's no guarantee you won't be selecting form C. There is a BrowseTo property (or is it event?) you could check out as a way of passing a value from one form to another. I've only seen it referred to in forums so I don't know if it's your answer. I don't use nav forms, mainly because of the way they work.