James,

BTW, this thread helped me too. I leaved with wrong assumption too long and fortunately for me John and Ed jumped into this thread and corrected me.

>>Jim,
>>
>>Have you checked the namebred table? What do you have in it? Also, why do you set RecordSourceType to 0? It should be 1, I think. You also don't need to set Columns controlSources, though it should not hurt, I beleive.
>>
>>I would try the following:
>>

>>if thisform.r_noloadhsfrmaddfoals
>>	return .f.
>>endif
>>select name, yr_bred from master where type = "B" into table namebred && could still be a cursor, I think
>>index on name to name && If it's a table, you now can use: index on name tag name, also note, that name is reserved VFP word
>>with thisform.hspageframe1.page1.hsgrid1
>>                .recordsource=''
>>		.recordsourcetype = 1
>>		.recordsource = "NAMEBRED"
>>*		.columncount = 2 && It's also not needed
>>		.column1.width = 200
>>*		.column2.width = 75
>>*		.column1.controlsource = "namebred.name"
>>*		.column2.controlsource = "namebred.yr_bred"
>>endwith
>>
>>See, if you will still have problems. If you do, please, e-mail me your form and I'll take a look.
>>
>>HTH
>
>
>Hello Nadya and All,
>
>I made the adjustments Nadya suggested and it now works, either creating a cursor or table. Thanks for the help and I apologize for taking so much of your valuable time but I do appreciate the assistance.
>
>I have no good reason for using the word "name" as a field name other than I didn't know what I was doing in 1986/1987 when I first started using DBASE III+ and now it's too late to change.
>
>I guess I don't know a whole lot more now but it's fun when it finally works.
>
>Thanks again,
>
>Jim Harvey
>jharvey@netrax.net

 If it's not broken, fix it until it is.


My Blog