i have a problem with flexgrid's in VB6.

i have a flexgrid that is linked to an MS Access database file via ADODB code.
the problem is that the flexgrid at run-time shows 2 rows from a specified table within the DB file. i want to be able to click on a row - i.e - the second one (index value = 2) and move it one place up.

i want to solve this problem by clicking on a command button called 'UP', but i dont know when to start. the code currently looks like this:

dim selectedrow as integer
dim endRow as integer

MSFlexGrid1.RowPosition(selectedrow) =destination