>Hi J
>
>When and how would I assign the myRecordset fields to certain DataGrid1 columns...?
>
>Thanks again!
When you assign your recordset as the datasource all columns from it are visible on the grid. You can't specify which fields show in which columns but you can control which are visible by changing their Visible property to False. For example:
DataGrid1.Columns(1).Visible = False
Where the columns collection is zero-based. If you want a particular order you need to control that with your SELECT statement. HTH,