>>Maybe someone could settle this once and for all. Is there a way to use a udf on a field as the controlsource for a column in a grid. I store a lot of data coded and use a conversion table to display the code. Right now I have to use an sql to do the udf and then use the resultant table (temporary) to as the source for the grid. A real pain.
>
>Why not fire the UDF in the INIT() of the object & leave the ControlSource as the resulting SQL cursor?
>
>HTH,
>Tom
This is in essence what I'm doing, but it is a pain when having to add/delete records to the cursor as I have to save it to a table.
I don't understand some of the underpinnings of how a grid works, but I
think it is really a glorified browse. Maybe this prevents you from using
udfs like in the old popups, but this was such a useful feature I would think MS could come up with a better work around.