General information
Category:
Forms & Form designer
>>>>>There is no code is Requery()
>>>>Colin,
>>>>
>>>>What is the rowsource for the combo? Is that causing the error?
>>>
>>>Hi Jim,
>>>
>>>The rowsource is an SQL-SELECT which works fine. I know this because the combobox works fine and I have been able to requery it from other objects on the form, just not the grids AfterRowColChange.
>>Colin,
>>
>>I understand the issue, I was trying to see if the SELECT has any reference to Parent in it. It may a bug that VFP is confused and thinks the current control is the grid when the select is running and it is looking at the wrong Parent property.
>
>Sorry about that Jim, I misread your answer. The SQL in the RowSource is as follows:
>
>SELECT Buil, Buildesc FROM BUIL ;
>WHERE PB AND Proj=This.Parent.Parent.Column9.cboProj.Value ;
>INTO CURSOR cBuillist ORDER BY Buildesc
First, I agree with Edward Pickman and Jim Booth.
Still, I would like to know what's the real cause of the error. Because if the This.Parent.Parent.Column9.cboProj is correct, it should work.
Are you sure you need 2 Parent in the above reference? Isn't it This.Parent.Column9.cboProj ?
It's rather easy to get confused when you use references like this.
Vlad
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only