One approach would be to:
1. create a public variable in a module.
2. when the user selects a record in Form 1, add code that sets the value of the public variable to the value of Field1
3. In the on-open event of Form 2 set the value of the combo box to the value of the public variable.
Create a textbox in the detail section and set the running sum to "Over all" and the control source to =1 and set visible to no.
then place the following code in the events procedure of the detail section. Substitute the names of your controls for Control1, Control2 etc. Each line...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.