Mike & Doris Manning
mikedorism at adelphia.net
Thu Apr 29 12:54:44 CDT 2004
You need to do the following: 1. Clear the dataset to dump the old data 2. Refill the dataset 3. Reset the grid's datasource to the dataset so it picks up the revisions 4. Refresh the grid. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Thursday, April 29, 2004 1:06 PM To: VBA Subject: [dba-VB] refresh data grid design I have a data grid that I set to a data set which I subsequently modified the SQL of. The data grid still shows the columns of the original SQL. Is there a way to cause the data grid to "refresh" itself and display the columns per the new SQL? John W. Colby www.ColbyConsulting.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com