Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PARENT is not an object?
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00065410
Message ID:
00065935
Views:
42
>>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
>Colin,
>
>Ok it looks like VFP is getting confused about what the current object is when you are calling the Requery() from teh AfterRowColChange. I have two suggestions;
>
> 1) refer to the grid from the outside in as in SELECT ... Thisform.Grid1.Column9.cboProj.Value
>
>or better still
>
> 2) use the alias for the table or view and the fieldname as in SELECT ... Proj = Alias.FieldName

Thanks Jim, and everyone else who replied. I decided to use your first suggestion and it works fine now.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Previous
Reply
Map
View

Click here to load this message in the networking platform