Variabel tabel til en forerpørgelse

Not quite sure I understand what you want, you say you have a number of tables, one for each month and have a listbox where you choose the month you want to see.
So why dont you put all the data into one table and have a column containing the date when the file was imported so that it can be used to select the data for the correct month (must use year too or you wont get the correct data)?

Det er en mulighed. Jeg ville dog helst hvis det kan styres på den måde jeg har skitseret.

Then you will need to build your query dynamically after you choose from the combo.

Something like this

CurrentDb.QueryDefs("NameOfQueryGoesHere").SQL = "SELECT * from " & me.NameOfComboGoesHere


Replace NameOfQueryGoesHere withthe name of the query which must already exist.
I assume that the month which is in th ecombo is the same as the table name so me.NameOfComboGoesHere should give you this. Otherwise you need some way to convert the chosen month to the name of the table.

Her har jeg brugt en combo, men det er det samme for listbox

Koden under knappen

Private Sub CmdMåned_Click()
Me.RecordSource = "SELECT * FROM " & CmdMåned
End Sub

thats a solution if the data is to be selected from a table, but the question doesnt say this.

.... tabel en forspørgelse skal dannes udfra.

jeg ser lige på jeres forslag og vender tilbage i morgen

thanks, I assume you got it working, otherwise drop a comment.

Øh vor kan jeg smide CurrentDb.QueryDefs("NameOfQueryGoesHere").SQL = "SELECT * from " & me.NameOfComboGoesHere
Skal det stå i sql i en forspørgelsen??? Eller hvordan gør jeg?

At a guess it would be in the after update event of the combo box.

Det forstår jeg ikke.
Jeg har min forsrpørgelse som eksempelvis ser således ud

SELECT Ark1.TEKST1
FROM Ark1;


Det jeg så gerne vil have er at når jeg kalder den skal den finde ud af hvilken tabel der skal bruges så sqlen ser således ud

SELECT [FORMS]![MENU]![navn_på_tabel].TEKST1
FROM [FORMS]![MENU]![navn_på_tabel];

Your welcome to send me your dB and I'll show you what I mean.

ekspertenATsanthell.dk
AT = @

kan du ikke sende et eksempel på skibbrogadeATtdcadsl.dk

yes

Super super. Det har virkeligt hjulpet mig meget.

great :o)