Bhavbhuti,

>I'll be adding fieldnames and commas in later code. Though the rowsource is being created right but this error I cannot seem to understand if the string being created is right then why does VFP complain?

The RowSource has to be completely valid when you assign it, you can't keep tacking stuff onto it. Build your string to a local memvar and then assign that to the RowSource once it's complete.