Synchronize ADO data control & ACCESS 97

[Bronco_P]

I load a table using SQL then I want to display the contents of the table in a data grid. The problem I am having is that the data control refreshes before the tables are completely updated therefore my grid only displays partial data or no data at all. How do I get the program to wait for the table update to complete before refreshing the control.

[paulw]

Don't bind the datagrid until the recordset has been created and then bind at run-time. Alternatively, turn off screen painting and use requery.

Cheers,

P.