I am using Access 2007 with iGrid. I have a readonly grid that displays records for a user to edit. Selecting a record opens a form that allows the user to change the data. I then close the form, rebuild the list (since the data could have changed) and return the user to the list. I would like to retain the sort setting that where in effect prior to the users editing the data.

I assume that I can do this by saving the grid's SortObject before rebuilding the list and then apply the saved SortObject back to the grid. Correct? Does anyone have a sample of code to do this (I'm not very well versed in working with objects)?

-- Rob

Why don't use the LayoutSort property? It automates what you need. Save this string and then restore it later.

Thanks. I looked all other the Help file and didn't see this property.

-- Rob