[RESOLVED] Calculation problem!

[cfd33]

Hello All,

I was going through a simple calculation program that I wrote not to long ago and just found a glitch in it.

What happens it that when a certain textbox gets focus, then a mini form will pop up that the user will use to make a calculation.

Once the user enters the numbers and hits calculate, then he clicks submit to send the info back to the main form. This works great.

The problem is this: when the user clears the main form for another calculation and when the mini form pops up; the user will enter numbers in again like he did the first time, but when he hits calculate the figures actually totals not only the new numbers, but the last cleared numbers as well.

Anyone know what is going on?

I have attached my project. When you get to the pop sales, then the mini form will appear. Enter some numbers, then hit submit. Now hit clear and start over and see how the pop calculator will add the numbers from before with the new numbers.

[MartinLiss]

The zip is missing frmPop and frmP2.

[cfd33]

Oops!

I try and see what happened

[cfd33]

I hope I got it this time.

Its like the program is storing the previous calculation in memory and not releasing it when the form unloads.

[MartinLiss]

I haven't loaded your new version but if you are depending on Unload to reset form variables it doesn't. In order for that to happen you have to set the form to Nothing. Is that the problem?

[cfd33]

Hmmm, that might be it. I will give that a try.

Something like this:

frmPop = Nothing

[MartinLiss]

Hmmm, that might be it. I will give that a try.

Something like this:

frmPop = Nothing

Set frmPop = Nothing

[cfd33]

Martin,

Thanks first of all for taking the time to help me.

Yes, I think that did the trick. I'm going to go over a few more times to make sure.

Thanks again!