>
> Hi James,
>
> In your case you should just use RecordSourceType=1 && Alias
>
> All other code looks just fine.
>
> HTH
Still isn't right, so I'm giving up on the cursor idea and going with the "into table nofilter" scheme. The only problem now is that all the grid is showing is the same record repeated over and over.
Here's the code in the init of the form:
if thisform.r_noloadhsfrmaddfoals
return .f.
else
select name, yr_bred from master where type = "B" into table namebred nofilter
inde on name to name
with thisform.hspageframe1.page1.hsgrid1
.columncount = 2
.column1.width = 200
.column2.width = 75
.recordsourcetype = 0
.recordsource = "NAMEBRED"
.column1.controlsource = "namebred.name"
.column2.controlsource = "namebred.yr_bred"
endwith
locate
endif
Any ideas on hwo to get the grid to show all the records, not just the first record repeated?
TIA,
Jim Harvey
jharvey@netrax.net