On Wed, 28 Apr 2010 03:21:01 -0700, Mike
<(E-Mail Removed)> wrote:
I understand you have a bunch of tables with same colums, and a
dropdown with those table names. Now you want to query the selected
table.
First off, you probably have a REALLY BAD database design that will
come back to bite you many more times. Create a relational database so
the problem will go away altogether.
Combo8 is also a non-descriptive name. How about cboTables?
Chances are I did not convince you and you will press on. To do what
you want, you would have to concatenate a string with the desired sql
statement. Something like:
dim sql as string
sql = SELECT " & Combo8.Value & ".DRAWING," & Combo8.value &
".[EQUIPMENT/CIRCUITS]," & etc.
-Tom.
Microsoft Access MVP
>On a form I have a ComboBox (Combo8). Is there a way to base a query on the
>value of what is selected in the ComboBox?
>
>Here is the SQL statement I've created, that is not working:
>
>SELECT [Combo8.value].DRAWING, [Combo8.value].[EQUIPMENT/CIRCUITS],
>[Combo8.value].[CABLE TYPE], [Combo8.value].[FND/SEQ], [Combo8.value].COMPT,
>[Combo8.value].LEX, [Combo8.value].ZONE, [Combo8.value].BILL, [23Tag and TM
>Data].[To Eq], [23Tag and TM Data].[To Desc], [23Tag and TM Data].[From Eq],
>[23Tag and TM Data].[From Desc]
>FROM Combo8 LEFT JOIN [23Tag and TM Data] ON
>Combo8.value.[EQUIPMENT/CIRCUITS]=[23Tag and TM Data].[Circuit Number];
>
>I am trying to join the "23Tag and TM Data" table to the table represented
>in the ComboBox (Combo8) and then run the query.
|
Similar Threads
