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