Results 1 to 4 of 4
  1. #1
    Join Date
    May 2006
    Posts
    3

    Unanswered: datagrid double click event

    i need help with adding a double click event to my datagrid. i want to be able to double click on a specific row in the datagrid and pull up the information in another form. i can now double click on any row in the datagrid and it will bring up the form but it always opens the first customer no matter where i click. any suggestions?

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Without showing us your code, we would just be guessing. And WAGs at that.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  3. #3
    Join Date
    May 2006
    Posts
    3
    Okay, here is my code for the DataGrid I don't really know where to start with the double click event. I want the double click event to bring up the info that corresponds with the CustomerNumber. Hopefully this helps.

    Code:
    Dim strQuery As String
    
    strQuery = "Select CustomerNumber, FirstName, LastName, TapAddress, TapNumber from tblCustomer"
    
    AdodcList.ConnectionString = MyMDBCon
    AdodcList.RecordSource = strQuery
    AdodcList.Refresh
     
    
    Set DataGrid1.DataSource = AdodcList
    
    AdodcList.Refresh

  4. #4
    Join Date
    Jun 2005
    Posts
    61

    Lightbulb here the answer man

    u have to write this if statment so u can transfer any raw to other forms u want

    If DataGrid1.RecordSelectors = True Then
    Ur Form.Text.Text = DataGrid1.Columns(0)
    Ur Form.Text.Text = DataGrid1.Columns(1)
    Ur Form.Text.Text = DataGrid1.Columns(2)
    .
    .
    . etc
    end if

    i hope this help u
    Sami Al Damiri ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •