Results 1 to 4 of 4

Thread: no duplicate value in the comboBox(Resolved)

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Feb 2005
    Posts
    81

    Resolved no duplicate value in the comboBox(Resolved)

    hi,

    I want to avoid the duplicate course tittle in the comboBox when I load the form. It is allow to add new course tittle if there is not in the combobox. I have try to search from the examples but none of them are relevant. Please help.

    Private Sub Form_Load()
    rs.Open "select * from Course ", con, adOpenDynamic, adLockPessimistic

    while Not rs.EOF
    cbProg.AddItem (rs("CourseTittle"))
    rs.MoveNext
    Wend

    end sub
    Last edited by vivian2u; May 6th, 2005 at 09:53 AM.

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