Member Avatar for 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...

  • 2 Contributors
  • 1 Reply
  • 101 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by purplegerbil
Member Avatar for 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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.