I have created a forum in vb6 and made connection with a database in access,everything went perfect.
my problem is in my form there is 2 combobox one to select Number and other to get me other numbers (watch the video to understand )
anyway the first combo is working and the second combo is working too but after selecting different number from the first combo i don't get anything in the second combo.anyway i know i just miss something in the code something very stupid
i have uploaded a video so you can see my problem, thanks in advance.
Private Sub Form_Load()
Do Until rspatient.EOF
Private Sub npa_Click()
Dim cr As String
cr = "npation ='" & npa & "'"
nom = rspatient.Fields(1)
prenom = rspatient.Fields(3)
While rshospita.EOF = False
If UCase(rshospita.Fields(14)) = UCase(npa) Then