Docmd.RunSQL
Private Sub Text58_Click()
Dim Naam As String
Dim strSQL As String
strSQL = "SELECT * FROM tblBank087 WHERE Naam = """ & Me.Text58 & """"
'SELECT * FROM tblBank087 WHERE [Naam ]= "Nobre";
Naam = Me.Text58
DoCmd.RunSQL strSQL, no
'Select Omschrijving Where Omschrijving Like
End Sub
I want to select a name from a dropdownlist but it doesnot work Iam new in Sql and VBA
waht the problem?
|