>>>>>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