Calling and prefilling a form from another form

[jlt199]

Hi, I have two forms, one that does pressure analysis on some data and one that applies temperature analysis.

If the user selects a checkbox from the pressure form then they are asked if they would also like to perform temperature analysis. If so the temperature form is loaded, so far so good!

There are common fields in both forms and I would like to prefill the temperature from with the values from the pressure form. I have some partial success here, this is what currently happens
1) fill in pressure form and click "OK"
2) pressure form is hidden -> so fields are still filled next time I run macro
3) I'm asked whether I would also like to run temperature analysis
4) I say yes and temperature form opens, ALL FIELDS ARE EMPTY!
5) I close temperature form
6) I run pressure form again and again state I also want to run temperature analysis
7) Temperature form opens, THIS TIME FIELDS ARE FILLED CORRECTLY

Can anyone please explain why I can get the filed to fill on the second itteration, but not the first?

An extract from my pressure from is

Please Login or Register  to view this content.

[Leith Ross]

Hello jlt199,

You had your Load and Show in the wrong order. When a UserForm is loaded, the window and all the controls are created. The controls' values can be set at this time to display when the UserForm is shown. Move the Show after the With and it work correctly.

Please Login or Register  to view this content.

[jlt199]

So easy when you know how :D

Many thanks

[Leith Ross]

Hello jlt199,

You're welcome. The Devil is in the details!