rst1.Open "SELECT Code_Ref,PrixSansR,PrixRemise from refer where designation ='" & txtREF&"'", con
txtREF = Replace(Combo1.Text, "'", "\'")
req = "SELECT Code_Ref,PrixSansR,PrixRemise from refer where designation ='" & txtREF&"';" msgbox req rst1.Open req, con
If rst1.EOF Then
msgbox "NbROWS = " & rst1.RecordCount If rst1.RecordCount >0 then Set DataGrid1.DataSource = rst1 End If
txtREF = Replace(Combo1.Text, "'", "''") & "';"
Private Sub Combo1_Click()
txtREF = Replace(Combo1.Text, "'", "\'")
req = "SELECT Code_Ref,designation,PrixSansR,PrixRemise from refer where designation ='" & txtREF & "';"
MsgBox req
rst1.Open req, con
MsgBox "NbROWS = " & rst1.RecordCount
If rst1.RecordCount > 0 Then
Set DataGrid1.DataSource = rst1
End If
rst1.Close
End Sub
txtREF = Replace(Combo1.Text, "'", "''") & "';"
If rst1.EOF Then
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionrst1.Close
Private Sub Combo1_Click()
On Error resume next
rst1.close
txtREF = Replace(Combo1.Text, "'", "''") & "';"
req = "SELECT Code_Ref,designation,PrixSansR,PrixRemise from refer where designation ='" & txtREF
rst1.Open req, con
If rst1.RecordCount > 0 Then
Set DataGrid1.DataSource = rst1
End If
End Sub