hi,

I create a report with two different conditions in the program.
In the form, there is a selection of Yes/No. If yes then will run the case 1 else will go to case 2.
I used sql statement to put the data into a cursor.

For the first time I ran the program, it will display the correct data for both case 1 and 2 but when I run another time without exit the form, both conditions(case 1 or 2) display the same data.

What should be the problem? I checked the program with a wait window, it running the correct codes but the data report displayed are the same.