>After I posted my question, I discovered something else about the grid. For example, if the grid has a recordsource of a cursor and the contents of the cursor change, you have to rebuild the grid properties such as columnwidth, column.controlsource, etc. Apparently, when a recordsource for the grid is rebuilt, all methods assigned to the grid disappear as well.
>
>When I first go into the form, all methods work perfectly. But the recordsource, which is a temporary work table created through an SQL statement, is reconstructed through user interaction.
Hi Terry,
I think this is a known fact about grids. If you are going to change the recordsource, set the grid's recordsource to NULL and after you have the new recordsource, set the grid to point to it.
Try this before rebuilding the whole thing.
Alex
Low-carb diet not working? Try the Low-food diet instead!