Results 1 to 3 of 3

Thread: Sql

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

    Unanswered: Sql

    What am I doing wrong with this code that populates a listbox?

    Code:
        Dim strSQLLineItems As String
        strSQLLineItems = "SELECT Line_ID, Transaction_ID,Stock_Nbr, Year, Make, Model, SellingPrice, AdjTotalPrice FROM tblLineItem WHERE Transaction_ID=" & Me.Transaction_ID
        Me.lstLineItems.ControlSource = strSQLLineItems
        Me.lstLineItems.Requery

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    forget .ControlSource

    use .RowSource
    ...and fix .ColumnCount .ColumnWidths

    izy
    currently using SS 2008R2

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

Posting Permissions

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