Hi, I was just picking up on this thread of populating a grid from a SQL Select statement.... what is the recordsource type in this case, Table?

Basically, I've defined a grid with two fields, lastname and firstname. I have a txtbox for lastname outside of the grid and I want all instances of lastname and firstname displayed for the last name that I enter in the outside txt box. (I'm querying for duplicate names...)

I've got a button that has the following in the click() method:

thisform.grdNames.recordsource=""
SELECT lastname firstname from namefile Into cursor crsTemp
thisform.grdNames.recordsource="crsTemp"

The source data file is contained in the data environment of the form.

--- L