>Ok, I put thisform.gridname.recordsource = tablename in the form init event. Now finally the form is showing data! That's some progress. BUT it is the wrong data! This makes me think that the record source gets changed somehow when the form is opening. How do I determine what the record source is at any one point so I can figure out what is going on?
Is the ControlSource set properly for each column in the grid? Is it possible that the grid columns specify alias.field in their Control.Source, and it's the wrong alias? Also, is ControlSource set in the data items within the grid (probably textboxes), overriding the column's ControlSource?
HTH,
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing