>>>>>>>if you did a quick report, the fields on the report most likely have another alias
>>>>>>>
>>>>>>>>maybe you have someother table set in the report's DE
>>>>>>>>
>>>>>>>>Arnon
>>>>>>>>
>>>>>>>>> thanks Sonny, but that did not work.. I do select my VIEW before the
>>>>>>>>> report form. At report time, it seems like to table is being re-set.
>>>>>>>>> rob
>>>>>>>>>
>>>>>>
>>>>>>thanks Dave ... I did not do a quick report...maybe someting is corrupted...
>>>>>>I have another program with the same code and I do not have this problem.
>>>>>
>>>>>May be in your textbox you have set table.text1 instead of view.text1 !!!
>>>>
>>>>thanks Sonny... that was it... In the textbox, I had mytable.text1 and
>>>>I should have text1...thanks again...I have a lot of fields on this report.
>>>>The only way to set the ControlSource for the report is to Right click
>>>>on a text box and choose PROPERITES. Is there another way?
>>>
>>>I'm sorry but I think there is no other way. They improve all the designer since Visual FoxPro. But they didn't improve the report designer much.
>>
>>This is how I made my mistake. When I designed the report, I added my TABLE in the DE. Later I took out the TABLE, because I created a SQL VIEW before the REPORT. When I took out the TABLE, the textboxes remained with the TABLE setting. I do not understand how I could make such an obvious mistake.
>>thanks everybody for helping..rob
>This is one of the reason why I try not to include aliases for the ControlSource property in the reports I create. This way, I could change between table, view, or cursor w/o resetting this property.
>
>John
hi John - I agree and I have learned my lesson...rob