Navigation between 2 Userforms

[rohanmalhotra]

Hi all

Need urgent help. I have prepared 2 userforms. First Userform has a button to open the second userform, however, as soon as i click on that button, the data from first userform dissappears.

Also, i have 2 common fields in both userforms but not sure if i can get the value in second userform from the first one.

i think this is too confusing.

Many Thanks

 

[kpark91]

Post your code and then we can see what the problem is.

 

[rohanmalhotra]

Hi

Below is the code :

Private Sub CommandButton1_Click()
    
    Me.Hide
    ApprovalLog.Show
    
End Sub

Private Sub UserForm_Activate()
Me.txtDateOne.Value = QualityLog.txtDate.Value
Me.txtWitemOne.Value = QualityLog.txtWorkitem
End Sub

 

[Case_Germany]

Hi,

do not know if I understand you correctly. Try the example:

UserForm1 to UserForm2

 

[kpark91]

Try changing your activate event to initialize event.

Private Sub UserForm_Initialize()
    Me.txtDateOne.Value = QualityLog.txtDate.Value
    Me.txtWitemOne.Value = QualityLog.txtWorkitem
End Sub

and I'm not too sure what you mean by the first data disappearing?
As long as the userform is not unloaded, it should be okay. But just in case you could also fix the first part of your code to explicitly load the next userform.

Private Sub CommandButton1_Click()
    
    Me.Hide
    Load ApprovalLog
    ApprovalLog.Show
    
End Sub

 

[rohanmalhotra]

not sure what i am doing wrong... i am able to open the second userform but all the data is lost from first userform