title: Error No value given for one or more required parameters with VBA
body: <p>I am getting "No value given for one or more required parameters", I am new in Excel VBA, Please suggest what is wrong with the query, Below is the code I am using to get the value from a access data based and I want to have the table name and the table column name on runtime. </p>
  
  <pre><code>Dim con As ADODB.Connection
  
  Dim rs As New ADODB.Recordset
  
  Dim name As String
  
  Dim count As Integer
  
  Dim FindString As String
  
  Dim FindString1 As String
  
  Dim SQLQuery As String
  
  FindString = InputBox("Enter the table name")
  
  FindString1 = InputBox("Enter search value")
  
  count = 4
  
  Dim strConn As String
  
  Set con = New ADODB.Connectioncon.Mode = adModeReadWrite
  
  If con.State = adStateClosed Then
     strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" &amp; "databasepath\Database3.accdb;Persist Security Info=False;"
  
     con.ConnectionString = strConn
     con.Open
     Set rs.ActiveConnection = con
  End If
  
  
  SQLQuery = "select * from " &amp; FindString &amp; " where " &amp; FindString &amp; ".[LOGO] ='" &amp; FindString1 &amp; "'"
  </code></pre>
  
  <p>rs.Open SQLQuery</p>