list boxes

Karsten, have you received the database I sent you?

Du kan f.eks. fylde listen med en række tal i formularens current-evet

Dim s as string
Dim iAntal as integer
Dim i as integer
iAntal = dlookup("[antaldele]","tabelnavn",[IDfelt] = " & Me!IDfeltIformular)
For i=1 to iAntal
  s = s & i & ";"
Next

Me!listbox.rowsourcetype = "value list"
Me!listbox.rowsource = s

Du kan sættes listboxens datatype som "value list / værdiliste" inden du starter, så behøver du ikke angive det i koden.
Ovenstående antager at der andel dele er hele tal og de ikke springer, hvilket lader til at være tilfældet.

Forstår ikke helt spørgsmålet.
Hvis jeg nærlæser spørgsmålet står der bl.a. "andre produkter".
Betyder det at hvis f.eks.4 er skruer og 5 søm, så får brugeren en liste over skruer, hvis valget er 4 og tilsvarende en liste over søm, hvis valget er 5?

hi terry
i am looking at the stuff you send and will let you know if it works... looks a little like what i had come up with... i would very much like to have these low or no stock items to be maybe marked in red og playing a song.....no just kidding but i mean this query is for non computer people who look through a lot of boxes everyday and to make there job easier i need to be able to generate a list of the products that have been removed say the day before...thus being low or out of stock since there is only 2 of each on stock sometimes 3. this is the query i had:

"SELECT Produkter.Navn, collilager.Colli, Produkter.Antalcolli, Count(collilager.Art) AS CountOfArt
FROM Produkter LEFT JOIN collilager ON Produkter.Art = collilager.Art
GROUP BY Produkter.Navn, collilager.Colli, Produkter.Antalcolli;"
the table names are a little different since i didnt have access to the real one when i send it to you so i made a copy from my memory....anyways the points definitively belongs to you so drop an answer and ill give them to you...

hippo:
det er ikke til en formular... databasen benytter en ASP side som frontend så jeg bruger ikke formularer i ACCESS...er det forkert? Kan det bruges så?

Karsten, ref your other question. If you had a table which contained the colli numbers which should exist then I'm sure we could find a solution, but the problem is we only have a field containing a number. This cant realy be used as a relationship to another table so we cant really use it in a streight forward SQL.

Another idea would be to ensure that the user DOES NOT enter a number in Antalcolli IF there are not that number of colli records. So I think you should solve this problem while entering data.

hallo