New Sum and label caption not working

Hello everyone.

I have sticky situation I am trying to get out of quickly. I thought I had come up with a quick fix, but things are not going as planned.

Take a look a the code below. What is important is the variable "Total Volume". This block of code works flawlessly, in particular the label "Total Volume" appears and the numerical value of Total Volume is correct.

Please Login or Register  to view this content.

Now, I am trying to modify that code block or script to include a new Label and variable called "Total Margin". Now this new label has been drawn onto the Userform that it is to appear, in fact it is adjacent to "Total Volume". So hear is the modified code:

Please Login or Register  to view this content.

First probem, the label does not show at all and secondly no sum of "Total Margin" appears on the label (due to the first problem). All the relevant data is stored correctly in the Access table. Both "Total Volume" and "Total Margin" are declared as Private variables and as double. Any help is greatly appreciated.

You don't have any code to set its caption in there (you set the caption for total volume). Also, if the Volume is greater than 0, then you don't test the margin at all.