|
-
May 4th, 2005, 03:57 AM
#1
Thread Starter
Lively Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|