Nummerering af fortløbende formular

There is no easy way to do this but here is a method which you could used.

THis is without anty filter. If you have a filter (WHERE) in the main SQL then this also needs to be added to the SUB SQL.

WITHOUT filter:
SELECT tbl1.*, (SELECT count(*) from tbl1 T1 WHERE T1.ID < tbl1.ID)+1 AS Nr
FROM tbl1;

WITH Filter:
SELECT tbl1.*, (SELECT count(*) from tbl1 T1 WHERE T1.ID < tbl1.ID AND T1.ID >1)+1 AS Nr
FROM tbl1
WHERE (((tbl1.ID)>1));

In the SUB select T1 is an alias for tbl1 and it is this table (T1) which you also need to filter

Jeg kan ikke lige se hvordan det lade sig gøre, når min formular er baseret på en tabel, betyder det at jeg bliver nødt til at ændre det til en forespørgsel?

Yes you must change it to a query. As I said, there is NO easy method to do this!

You will very likley also find that you can not alter records. This is becuase youhave a calculated field in the query.

Jeg har besluttet mig for at beholde tabellen og så oprette et ekstra felt i den som tæller hvilket post i rækken det er. Også besværligt, men det kræver lidt færre ændringer. Du får dine point for at bringe mig på sporet, så tak for det;-)

thanks fcjohn

Not sure how you can use another field to show the order, what happend if you add new records or delete some?

Jeg tror så at jeg har droppet det helt, brugerne må bare nøjes med en liste uden numre, de overlever nok. Jeg løb ind i de problemer du beskriver, så jeg var bare for hurtig...