Sub armar_consulta()
Dim ds As New DataSet
Dim da As OleDbDataAdapter
Dim sql As String
sql = ""
If Trim(Me.TextBox1.Text) <> "" Then
sql = "acestnomb like '%" & TextBox1.Text & "%'"
End If
If Trim(sql) <> "" Then
sql = "SELECT acestnreg,acestnomb,acestcarr,acestplan FROM acest WHERE " & sql & " ORDER BY acestcarr"
Else
sql = "SELECT acestnreg,acestnomb.acestcarr,acestplan FROM acest ORDER BY acestcarr"
End If
da = New OleDbDataAdapter(sql, con.cnn)
da.Fill(ds, "consulta_acest")
DataGrid1.DataSource = ds.Tables("consulta_acest")
End Sub