Results 1 to 2 of 2

Thread: access Pro? duplicate combo box

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Sep 2001
    Posts
    75

    Angry access Pro? duplicate combo box

    Using Access to check for duplicate item else add to list

    shouldienter = Combo25.Text

    For i = 0 To Combo25.ListCount - 1
    If shouldienter = Combo25.List(i) Then
    Exit Sub
    End If
    Next i

    Combo25.AddItem shouldienter

    The problem is acess does not have function .List()
    anyone knows alternative?
    Need help guys
    We Jammin

  2. #2
    Frenzied Member PilgrimPete's Avatar
    Join Date
    Feb 2002
    Posts
    1,313
    Access combos have a Column property, so you can access a particular column and row like this:
    VB Code:
    1. Combo25.Column(iColumn, iRow)

Posting Permissions

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



Click Here to Expand Forum to Full Width