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

    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
    Arizona, USA
    Without showing us your code, we would just be guessing. And WAGs at that.
    "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
    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.

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

  4. #4
    Join Date
    Jun 2005

    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