How to manipulate an msflexgrid?

[janeane_tho12n]

frankly speaking i dont know how to start my code.

my problem is i need to put the contents of a database in a graphical format (i plan to use msflexgrid for this). whenever the user click a certain row of record, a form will appear and from there the user can change the contents of that record. no change can be made on the flexgrid. help me againb with this one plzzzzzz...

[purplegerbil]

Hi,

If I am reading it right, you want to be able to open another form when a user clicks onto a line of the FlexGrid.

Option Explicit

Dim myRecord As Long

Private Sub MSFlexGrid1_DblClick()
    
    myRecord = MSFlexGrid1.Row
    
    MsgBox "Selected record: " & myRecord
    
    ' Load edit form using record ID to search database
    ' for selected record
    
End Sub

pG