Hi Vince,
is curplants the recordsource if a grid on the screen? If so then move focus away from the grid prior to running the report. The grid is greedy and tries to get it's controlsource selected all the time.
Frank.
Frank Cazabon
On 05/02/2021 8:59 am, Vince Teachout wrote:
I've already implemented a work-around, but I'd like to know what's causing this.
I have a report that builds a list of plant locations (curPlants), then builds a cursor full of data for a report. (cList)
When I'm ready, I do this: Select cList Report Form MyReport blahblah
It INSISTS on making curPlants the current cursor, massively messing up the report. I checked and there is nothing in the report data environment, or TAG1/TAG2. I set the DE initial cursor to cList, and get the same behavior. There is no mention of curPlants in the report form anywhere (It runs fine if I CLOSE curPlants)
During debugging I stopped it, verified it was on the correct cursor with a browse, let it proceed - and it worked just as it should, using cList. Also during debugging I accidentally introduced a non-fatal error. It stopped, I ignored the error, and it proceeded to work correctly, using cList. Remove the error line, and don't pause... and it selects curPlants. WTH?
I got around this by CLOSEing curPlants, which is less than Ideal, because then I have to close the screen, so they can't run multiple reports, but it's acceptable. Any Ideas? I wasted several hours on this.