S
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
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