Post #4320352

@blaise This is the most common cause. If the code iterating through or preparing the recordset left the cursor at the end (EOF), the DataGrid binds to the current position forward. Since there are no records "ahead" of EOF, it renders zero rows but retains the schema (column names). Fix is explicitly reset the cursor to the beginning before assigning the datasource. ' Reset cursor to the first record If Not rs.EOF Then rs.MoveFirst End If Set DataGrid1.DataSource = rs DataGrid1.Refresh 1.Reset cursor to the first record 2.Assign the datasource which is rs 3.Force a refresh if the grid doesn't auto-update 3 separate commands The End if is not there for a joy