>I have a grid that uses a cursor name as the RecordSource and RecordSourceType = 1. I use the builder to setup the look and feel of the grid in the designer. When I fire up the form, it looks great with all my custom column heading and width the first time. However, once I use a SELECT statement to update my cursor, all the formating were gone and the column headings became the field names. What can I do to prevent that?


Stephen,

A grid looses all it formatting as soon as its RecordSource cursor is closed/destroyed. A SELECT statement doesn't update a cursor. It closed old one and creates new one with the same name. To prevent closing of the cursor you can ZAP it and than use INSERT INTO ... SELECT FROM to repopulate it.