How to use a variable within SQL code that is embedded in Visual Basic

[VBnewb13]

...Sorry if that question was confusing. Allow me to explain better:

I currently have this line of code:

Forms!form1.RecordSource = "SELECT * FROM Table1"

My problem is that I have more than one Table I would like to select data from (not just Table1...there is also Table2, Table3, etc). I have a combo box that lists all of my tables and I would like to be able to select a table from the combo box and have the data extracted from the corresponding table.

I was thinking about maybe using some sort of variable but I do not know how to go about doing that. If I were to write it in logic form it would read something like:

let the value of combo1 = $displayTable
Forms!form1.RecordSource = "SELECT * FROM $displayTable"

I'm sure that does no good in code but I hope it helps explain what I am trying to accomplish.

Thanks

[patjones]

The syntax that you're looking for is this:

form1.Recordsource = "SELECT * FROM " & Me.combo1

You just need to make sure that when you make a selection from the combo box, it's actually setting the value of the combo box to the string (table name) that you're selecting, and not some numeric value (index).

Pat