>I agree with John's idea to use SQL in place of the FOR clause, but are you absolutely positive you have the correct table SELECTed before calling the REPORT? It's an easy mistake to make.....
>
>HTH
>
>Barbara
>
>>>What code is in the Click()??
>>
>>Here it is:
>>
>>Local ldFrom, ldTo, lnSendTo, lcDest
>>lnSendTo = ThisForm.OptSendTo.Value
>>lcDest = Iif(lnSendTo = 2, 'To Printer', 'Preview')
>>ldFrom = ThisForm.txtFrom.Value
>>ldTo = ThisForm.txtTo.Value
>>Report Form Total For Between(TotalDate, ldFrom, ldTo) &lcDest ;
>> Heading "From "+DTOC(ldFrom)+" To "+DTOC(ldTo) NoConsole
>>If lnSendTo = 2
>> Wait Window "Report Sent To "+pPrnName Timeout 2
>>Endif
>>ThisForm.Release
>>
>>TIA
Haven't tried the SQL approach. The table where the report comes out loads in the report DE, not in the form. I have reindexed the table, but to no avail. I also believe that if it was a problem with the table I should be getting the same error in the development environment too. I'm thinking it may be something to do with corruption of the form file. I'm recreating the form at this time.
Thanks for the reply.