I am trying to use a select query for my from clause to access a table name. The reason being is I want the user to be able to select a table from a combobox without the prepended "tbleq...". So, I have a table named "tbleqMCC" and I want the combobox to show "MCC". That part works okay. Then, based on user's selection in the combobox, I want to show data from that table. That part is not working. My SQL looks like this:
SELECT Replace([ID], [ID], "tbleq" & [ID])
where ID = [Forms]![Main]![combo26]
The result is just the table name, not the data within that table.