>Ok - I use an SQL select statement (SELECT * from parts WHERE ponum=mponum INTO TABLE partstank.dbf) to get records into a table. I have a grid that is to display the records in partstank.dbf. I set the grid RecordSource to partstank.dbf (also tried just plain 'partstank'), and the RecordSourceType to either Table, or Alias. I have set the Column ControlSource and the textbox ControlSource to the partstank file, which I know has records in, but nothing shows up in the grid.
>
>Any ideas??
>
>Thanks.
Use a cursor and alias for the RecordSourceType. Use Alias.FieldName for the control source of grid columns.
If it's not broken, fix it until it is.
My Blog