I have a modal CHOOSER form which contains two list boxes. The list boxes point to cursors which are populated in the form's ACTIVATE based upon a passed parameter (DO FORM Chooser WITH "Manufacturer").

Every SECOND time I run this form from my application, I get the error: "Cannot Access Selected Table", and one of the list boxes disappears. When I run the form a third time, it works OK.

I've tried SELECTing a real table to make sure the form is not on a non-existant cursor at the wrong time - but....

IAC - I suspect I'm putting my SQL to cursor queries in the wrong place. Which method should this stuff go into?

TIA