Hi! I have a grid which ordered is based on a date field. This grid uses optimistic table buffering.

When a new record is added via a command button when the user tabs off the date field I issue a refresh and the grid is reordered.

However, when another record is added the and the user tabs off the date field the refresh in my lost focus does not reorder the grid? Is this somthing to do with the data buffering?

If I then save the changes (& tableupdate), if I close the form then run the form again & start again then 1st new record I add is reordered, then any additional records are not as above?

Can anyone put me out of my misery, and shed some light on this ?

Yours hopefully
Robin