There seems to be far to many places to put things in grids. When I do it, I leave the grid's recordsource blank, fill in the column control sources with table.field, and leave the textboxes and such within the column blank.

Works most of the time. :)

-Michelle



>Hi Michelle,
>
>I ran into a problem very similar to this recently. Although I understand you got your grid working again thanks to Edward and Garrett, I thought it might still be helpful to let you know what happened to me.
>
>Like you, I had a grid which had been working fine for quite some time. I then changed the structure of the underlying table, and renamed one of the fields which is displayed in the grid. In the form, I changed the controlsource property for the textbox for that field to the new field name, but I forgot to make the same change to the controlsource for the column which contains the textbox. The result was that the grid showed up with no data in any of the columns. Drove me crazy for about a day until I figured it out.
>
>Although I didn't try it, I'm guessing Edward's solution would have fixed my problem if the correct controlsource name for the column were used in the ResetGrid( ) method, thus overriding the original, incorrect value. But for me, anyway, fixing the controlsource in the grid property itself solved the problem without needing a ResetGrid( ) method.
>
>HTH,