How to refernce table name from textbox value

[Moss100]

Hello I have a line of code which set the table name to be used as below:

strSQL = "SELECT * FROM [1250]"

That runs fine and returns all I need from table 1250

If however I have a textbox on the form called texttable which contains the value 1250 and change my code to:

strSQL = "SELECT * FROM & Me.[texttable]" it errors.

What is wrong here and what would make things work?

Many thanks Mark

 

[dhookom]

SQL doesn't understand Me or a text box value. Try:

strSQL = "SELECT * FROM [" & & Me.[texttable] & "]"

Duane
Hook'D on Access
MS Access MVP

 

[Moss100]

Thanks kindly