>I'm using a grid class for a similar purpose. What I've done is have a base form that it's on and assign the RecordSource in the form's Init. The grid's RecordSource has an assign method that then fires and does things like replace logical fields with check boxes and so on.
That's near enough what my grid baseclass does but as I wanted the recordsource to be a IIF statement it was getting confused
It was looking in the data dictionary for a field called IIF(...) not finding it and putting the entire statement for the column header (It also looks to the DD for alignment (header and data) and formatting etc)
I have ended up hiding this column in the grid and showing a "calculated" field instead - it's not neat or generic but it's simple and works.
Thanks for everyone's input on this - It's given me a few ideas for next time :)
Will
Will Jones