>>>>This line of code causes my report to flash onto the screen and then disappear.
>>>>It's been a while since I created a report, but I think a line such as the one below used to work. Have I made an error for the very first time in my coding career?
>>>>
>>>>Report Form incident For Alltrim(crimetype) = "Vandalism" PREVIEW
>>>>
>>>
>>>Maybe you don't have 'Vandalism' anymore? :)
>>
>>I wish!;-) It's in the table.
>
>I got it - The data environment was hooked to a test table in another folder. Sorry folks.
I think lots of people tend to upper() strings for indexing. If you
INDEX ON UPPER(crimetype) TAG ixcrimtype
Then this command
REPORT FORM incident FOR UPPER(crimetype) = "VANDALISM" should be Rushmore Optimized. However it still won't work if you're hooking to the wrong table. :)