>
>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
