Send UserForm value to another UserFrom

[Pacman52]

Hi all I am really lossed on how to code a button on a small userform that will send the value in it to another userform

I have a main form called 'frmExpenses' part of this form is a textbox to record the total mileage. A user can either enter a number directly or thay can press a button called 'frmMileCalc' to enter the daily mileage to get a total.

'frmMileCalc' opens another form which allows a users to enter the daily mileage in various textboxes and totals it all in another textbox called 'txtTotalMileage'.
when the button 'buttonTransfer' is clicked I would like the total mileage value to transfer over to the orgonal form so that the user can carry on completing it and then writing all the values to the worksheet.

I've tried numerous methods to get this to work but no joy dispite many many searches on google ect.

Could someone please let me know firstly if this is achievable and if so how do I do it?

Many thanks

Paul

 

[RoryA]

Assuming the code is in the second form, it could simply be something like:

frmExpenses.textboxname.text = me.txtTotalMileage.Text

 

[Pacman52]

Thanks Rory but I've tried that already and it didn't work but having just checked I've just noticed that frmExpenses closes when the mileage form opens

Could this be the issue?

 

[RoryA]

Even if it is closed, the code would load it. I suspect you have made the common mistake when switching from one form to another of attempting to unload the first form in the same code that loads the second form. That won't actually work. The code in the first form should hide the first form then show the second (at which point it will pause if the second form is modal, as is the default). The second form should not attempt to unload itself, it should merely hide and then the first form resumes control at which point it can read the relevant control in the second form (or a custom property that you create) and then unload the second form.

 

[Pacman52]

Thanks for the info Rory. I hadn't actually coded the first form to do anyting I just assumed as I hadn't told it to close it would just hide itself but that just highlights my lack of knowlege on VBA but thankfully with great advice and support on this forum I'm learning fast !

Thanks again

 

[RoryA]

If you didn't code the first form to do anything, then it should just sit on screen when the other form opens and remain there when the other one closes.