Hi,
I'm having a heck of a time with a grid that I'm using in one of my forms, here's the problem:
My grid's recordsource is set to a cursor. Every time the user clicks on a different date, that cursor is re-created on the fly with the updated information. Once the cursor is re-created, however, my grid loses all it's properties (formatting) and looks pretty sad. That's why in my method which performs the SQL statement which re-creates the cursor, I re-format my grid.
The point is, I don't want to have the grid's properties get reset on the fly because that presents problems with my textbox class which is in the grid columns (and calls right click menu, etc.).
Does anyone know of a way I can keep the grid from losing it's formating properties whenever I recreate the cursor that's used as it's recordsource?
Much appreciated for any help!
-JT
P.S. I want to avoid using a view here if possible due to the complex nature of my SQL statement (view designer does not like more than one join and UDF calls).
Jeff Trockman, MCP