Sub forms procedure execution order

[Stapes]

Hi

I have a Booking Form which contains 2 Sub Forms, Customer Details and
Booking Details.
I also have a Customers form in a seperate part of the system, and I
am trying to make a link - New Booking, which opens the Booking Form
with the selected Customer Details, ready to add new booking details.
I used a global variable glob_form_name. When the New Booking button
is clicked on the Customers form, it sets glob_form_name to
"Customers". In my Booking Form, I put On Load procedures in the
Customer Details subform and the Booking Details subform. In the
Customer Details form , if glob_form_name = "Customers" then it finds
and displays the details of the Customer selected in the "Customers"
form. in the On Load procedure for the Booking Details form, I put if
glob_form_name = "Customers", DoCmd.GoToRecord , , acNewRec.
It stopped working correctly - no longer displaying the correct
customer details. I put some displays in to determine the order of
execution of theses various procedures, and was surprised to learn
that it executed the On Load procedure for the innermost subform
first!!
How do I get it to display a new Booking Details record?

Stapes

 

[Guest]

The OpenForm action allows the use of the OpenArgs parameter. Rather than a
global variable, you can pass a parameter at a more localized level. Maybe
your global variable is getting crushed by something.

Other than that, I don't understand what is trying to be accomplished.

 

[Stapes]

The OpenForm action allows the use of the OpenArgs parameter. Rather than a
global variable, you can pass a parameter at a more localized level. Maybe
your global variable is getting crushed by something.

Other than that, I don't understand what is trying to be accomplished.







- Show quoted text -

No - my global variable is just fine. How do I get it to display a new
Booking Details record?