Ulises,
Grids often cause problems when the data they show is changed/updated with a new query or SELECT statement. Before your SELECT statement, blank the grid recordsource with

Thisform.Mygrid.Recordsource = ''

then when you have the new data set ready reset the recordsource

Thisform.Mygrid.RecordSource = "MyCursor"

HTH
Barbara

>I need an expression that locates the MAX number in a field among a given set of records of another field. (Like the MAX levelNo among codeNo=1.)Ed Rauh kindly gave me this:
>
>SELECT MAX(LevelNo) AS MaxLevelNo FROM MyTable WHERE CodeNo = 1 ;
>INTO CURSOR whatever
>
>however this causes my grid to go blank afterwards. Is it posibble to construct a LOCATE sentence that do this? I need badly a way to solve this problem.
>Thank you very much.
>
>Ulises