Calculation using Combobox output

[Evon]

So if I change one of the properties in a control, the whole form populates again nicely, like changing a combobox to a textbox and their properties and vice versa. Then when I close the database the Nz fields go back to #Name.

So,over to you my access guru.

I am wondering if I should scrap this project and start from scratch.

 

[Evon]

Found the problem. Examined the code for the form that opens with the database and found a code that Access was trying to run on "got focus" . However, I had renamed the control.
So I deleted the Private Sub code.

Still, big-up to my new friend pbaldy anyway and nuff respect, and sir we are going to change your moniker from "pbaldy" to "pdready".

 

[pbaldy]

Sorry, lost track of this thread. Glad you got it sorted out.

I will proudly carry the pdready moniker, though my hair is too short and too fine to do dreadlocks. My wife has had them, so she'll have to carry the family "dreads" honor.

 

[Evon]

Point taken my friend.
Anyway, I have another one for the forum. Been doing my research as usual, but still have not found a solution that is understandable at my level:

I am working in a form that will generate an invoice report. The form is set up to facilitate 10 lines per page on the invoice report. However, there are times when the invoice I want to generate has more than 10 lines/items and would need to go to the next page for it to be completed.

In the form, I would like to carry forward the first page total to the second page at the top, to be added to the other item totals on the second page.

How do you suggest going about achieving this?