>>>My trick for this is to set the grid's recordsource and all the columns' controlsources at design time, and then just make sure all of them exist at runtime. I have to confess that I'm doing almost all of it in command window :).
>>
>>I wasn't sure whether that would be allowed, setting controlsource names in a grid before, possibly, the actual cursor is created.
>
>No problem at design time. At run time, make sure the cursor exists before the grid instantiates.
Which it would do, at .Load, as that's evaluated before the grid is.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.