Table name stored in variable and SELECT statement

[Bloosy]

Hi everybody
I have a table name stored in a variable. Now is there any way that I can use that variable in SELECT statement.
Example:

Dim rs As Recordset
Dim whichmenu As string
whichmenu = "tablename"
.
.
rsname = "SELECT * FROM whichmenu WHERE field1 ='" &_ something & "'"
Set rs = db.OpenRecordset(rsname, dbOpenDynaset)

The point here is that I don't know the name of the table, it is only for simplicity

 

[SonOfEmidec1100]

Just build the the table name into the query like the where clause parameter. Not sure of the purpose of the _ character.

rsname = "SELECT * FROM " & whichmenu & " WHERE field1 ='" & something & "'"

 

[Bloosy]

Thank you. The _ is from books, meaning that the next line is the same line in your code. Not in right place here