>>>>>>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
It's "my" world. You're just living in it.