Dennis --
Yes, that's exactly what I've done. Inelegant at best.
But is this a bug? That's hard to say, because I don't know what else is going on. In any case, I've always wondered by refresh didn't do the trick.
Jim
>James,
>
>Hi. This has also been my experience. What I do is everytime the form the grid is in has been Activate(d). I put code in the form's Activate event to setfocus to the grid. Not elegant to say the least.
>
>How do you tackle this problem? Is this a bug?
>
>
>>It's been my experience that this works as long as the grid has the focus. If not, it
may happen that the fields from tables other than the grid's recordsource may not display properly. (And the user can correct this by setting the focus on the grid.)
>>
>
>Thanks,
>
>Dennis
Jim Nelson
Newbury Park, CA