This query works find when I call it for one table but for another table from excel. I get "no value given for one or more required parameters".
SQLStr = "SELECT " & table & "." & "[" & recordlabel & "], " & table & "." & "[" & returnvalue & "]" & " FROM " & table & " WHERE (((" & table & ".[" & recordlabel & "]) = " & recordid & "));"
Both tables exist and the fields I reference exist so I'm not sure what the problem is.