Navigation Form Subform Code issue

[johnnyBQue]

OK guys and Gals here's my next installment of what has he done now...



Created a Nav form that works as it should ....to a point I have several tabs that connect to forms and they open as they should BUT I have this one form that I called "HOME" where a greeting message appears to the user once a successful login has been performed. My issue is part of my Greeting msg appears ONLY when you click the "HOME" tab button after the Nav form opens.

Now the code I'm using is as follows:
Quote:

Private Sub Form_Load() Me.txtWelcome = Forms![Navigation form]!txtUser.Value If IsNull(DLookup("[UserName]", "tblUser", "[UserLogin] = '" & [txtWelcome] & "'")) Then Me.welcome = "Greetings" & "..." & Me.txtWelcome End If End Sub

Now the code in RED I'm pulling a value from the MAIN form that is to appear in the sub-form "HOME"
again the problem is NOT that I'm getting the wrong data it's when it appears

When the Nav form opens the "HOME" tab is a Darker shade of blue than the others and is the form that appears on the screen first like I mentioned earlier, BUT this maybe misleading me to think that focus is placed on this tab at this point .....Only to find out that the focus may be set ONLY when I click it for again that's when the other text data appears which is the "Me.txtWelcome" data (or users name) the "Greetings..." shows up when the form first opens like I want it to.

Oh one more thing the txt.User.value has data in it after the User successfully logs in. It shows this in the txtUser text box in the Main/Parent Nav form. AND I'm working on the "ELSE" I wouldn't think this was the issue that I'm seeing here now...

now can someone narrow my lack of knowledge to a more focused area...

[RuralGuy]

Try adding a Me.txtWelcome.SetFocus
...at the end of that procedure and see what happens.

[johnnyBQue]

Yeah tried that, but no effect....I was given some information that I'm looking into and that is the Parent form actually loads last and the sub-forms load first...seems that the set focus should be the last thing that happens...If "setfocus" is the fix in some way...

[RuralGuy]

Absolutely, any SubForms load *before* the MainForm. Where is the txtWelcome control located? The TAB object is just an extension of the Form on which it is located and not really a control in the truest sense.

[johnnyBQue]

The txtWelcome is located in the Navigation subform under the HomeTab (well within the Nav subform seeing how the HomeTab isn't an actual control)....I have the control source set to a text box called txtUser (now... the code in red above I've nz'ed at this time but the issues as to when the data appears is the same for both methods) from the Main/Parent form where the users name appears after the user logs in. The data links correctly it just getting it to appear when the Nav form opens after the user logs in without have to click the "Home Tab" in the Nav form...

NOW if the subform loads first...is there data in the Main/Parent form (txtUser) at that time to be linked to the subform (txtWelcome) or does the Main/Parent form have to load before the data is linked/available to txtwelcome...and thats why it appears after the clicking of the Home tab it updates the text boxes?..?...in the Nav subform?..?..

If so then I need to get the correct data in txtUser so when txtWelcome loads it has data to retrieve?.?.?

[RuralGuy]

It sounds like you need code in the Load Event of the MainForm to do what you want. By then all of the SubForm should be loaded and all of the Controls on the MainForm and the SubForms are available to reference.

[johnnyBQue]

I agree, .... thanks

[johnnyBQue]

WAIT...why code in the Load Event in the "MAIN" form when the subform loads first? I take it you mean code that makes the Main form place the data (txtUser) into the txtWelcome (in the subform) and then setfocus (to emulate clicking the Home Tab) which causes the name to appear after the forms loads....

Hmmm...I'll have to check on how to do that ....currently nothing happens on the load event of the "Main" form except a close command....

I'll look into it.....

[amrut]

Expert is already helping you out. I just want add to it.

My issue is part of my Greeting msg appears ONLY when you click the "HOME" tab button after the Nav form opens.

In case of Navigation Forms, there is ONLY ONE sub form control and the respective forms get loaded when you click on the navigation button.
this is from a MSDN article.

Because the navigation form loads each form as you click the corresponding tab, you can be certain that users see the most current data, without a need for you to create specific code that re-queries the form as users click each tab. This also means that the navigation form does not provide a specific event as you click each tab. Instead, place the load-time code in each form or report Load or Open event handler.

Here is more info http://msdn.microsoft.com/en-us/libr...ice.14%29.aspx

[johnnyBQue]

Couldn't figure out the reason why....I'm blaming it on the navigation form.....but I did a work around using the "Detail area" not the subform area and got the results I wanted thanks all that helped.

[RuralGuy]

Glad to hear you are good to go.