MSFLEXGRID problem

[chilun_liu]

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

[MartinLiss]

1. Save the data from row 1.
2. Copy the data from row 2 to row 1.
3. Replace the data in row 2 with the saved row 1 data.

[brucevde]

To move the current row up 1



With Me.MSFlexGrid1

lngRow = .Row - 1

'make sure the row is not being moved onto a Fixed Row.
If lngRow >= .FixedRows Then
.RowPosition(.Row) = lngRow
End If

End With