>Mark,
>
>I have had this problem with using List Controls and such as well. This may seem stupid but try this. After the user selects the new Fiscal Year. Set the Grid's RecordSource to SPACE(0) then set it back to what it was originally and then issue a Refresh() on the Grid.
>
>It seems to work!
I had tried that as well with no luck. What I had to do was change the Grid from ReadOnly = .t. to ReadOnly = .f., then do a requery, switch ReadOnly back to true, then refresh the form. All these idiosyncracies are hard to keep up with. Maybe *we* should start a list...
1. NEVER, NEVER Nest Joins.
2. Switch ReadOnly grid property to false before a requery of its record source.
3. others I can't recall at the moment but have cost me much time in the past...
Mark McCasland
Midlothian, TX USA