Try setting the recordsource propert to '' before making changes to the cursor and then setting it back to the name of your cursour after you are done.
>Help!!!
>We are trying to create a grid from a table which is created dynamically based on a user selection. Everytime we set the recordsource property of the grid to this table, we lose all previously set properties of the columns. All coulmns appear resized and difficult to read unless manually re-adjusted. Without going through storing previous properties to arrays and then restoring them, is there another easier way to restore properties??? The field names for the table created will always be the same.
>
>Any help will be appreciated.
>
>Thanks,
>Binoy Warrier
--Todd Sherman
-Wake Up! Smell the Coffee!