Results 1 to 2 of 2

Thread: ListBox

  1. #1
    Join Date
    Mar 2004
    Location
    Atlanta, GA
    Posts
    58

    Unanswered: ListBox

    I have this code attached to a listbox and when i run the code it doesn't pull up a record. What am I doing wrong?

    Code:
    Private Sub lstLineItems_DblClick(Cancel As Integer)
        
        DoCmd.OpenForm "frmLineItemDetails", , , "Line_ID=" & "" & Me.lstLineItems.Column(0) & ""
        
    
    End Sub

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Call the value of the listbox instead of referencing the column property.

    DoCmd.OpenForm "frmLineItemDetails", , , "Line_ID=" & Me.lstLineItems.Value

Posting Permissions

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