>>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.comNever mistake having a career with having a life.