I'm running VB SP5 not SP6 - heard tooo many bad things about it!

Naah not getting confused with TOPROW (that doesnt seem to be a property on mine) - I've got a datagrid that I am using a combo box with, to alter values - it actually alters an underlying SQL table but the results are queried using a SQL view i.e. 1 = Supplier1, 2 = Supplier2 etc - the view shows the Supplier1 whereas the table shows the ID 1. Once the value has been changed in the table it needs to refresh the datagrid & place the pointer back exactly where it was on the datagrid & physically in the same place too so not to confuse the user - hence the reason to set the FirstRow in the datagrid to what it was before the recordset was refreshed.

I've just managed to sort it now by setting the bookmark property of the recordset to the firstrow value before it got refreshed then setting the bookmark value to the record pointer!!! So easy when you think about it - was pulling my hair out all yesterday afternoon!!! Fresh head and all that.....

I've seen Delphi - thats basically a windows based Turbo Pascal is it not - used TP7 programming language when I did my A levels. I would like to look at another programming language prob VC but I never seem to get time to play with it!! TBH I'll probably move onto VB .NET as its the next logical step!!