Please let me know how the previous test worked. I'm going to assume it worked, and here is the next test:

In one of your methods (the one you posted code from at the beginning of this thread), you have code that fails. I want you to comment out that entire block of code. From the SELECT statement, all the way to the ENDSCAN.

Is there code that was already in that method? I want you to leave it there.

Then, in the new commandButton click() method, change lnCurrentSeason to another value (so you can observe changes in product table).

Compile your exe and run it.

Pull up an invoice (preferably the one you have hard coded in the commandButton). Click on your save button (or whatever button makes it run the code you were originally trying to run). Then, click on the new commandButton.

Any errors? Did it update the product table?

Do you see why we are doing it this?