Requerying

[H. Martins]

One of the fields of a table is sorted.

SELECT tblConfigGrupos.lintIndexKMaster, tblConfigGrupos.strNomeGrupo,
tblConfigGrupos.boolInactive, tblConfigGrupos.lintNGrupo FROM
tblConfigGrupos ORDER BY lintNGrupo;

If I change the content of one lintNGrupo field in one record, I
should issue a Me.Requery to sort it again so that the new sort is
displayed.

To what event should I associate the command?

(Is this the right way to do it?)

Thanks
H. Martins

 

[Douglas J. Steele]

Try the form's AfterUpdate event.