Læg 1 til felt i Access 2000 - (igen)

where are you using dmax?

As far as I know you can NOT use dmax in the default value! So you should use it in the BEFORE UPDATE event for the record on  a form.

OK - Is there ANY way to get the autoincrement going in the default table value ?

IF you set the field to an autoincrement (TYPE) then it will add 1 for you WITHOUT setting the default value!

Yeah, but with this one its supposed to be editable and find the highest number each time and go from there (+ 1) - Isnt there some way to determine the value from the previous post and then add 1 to that value ?

YES but you MUST do it through a form. In the form you will also need to check to make sure that the value doesnt exist already!

In the on current event you can test if the record is a new record and iF it is set the field (default)

If me.newrecord then
  me.Thefield = Dmax .....


Then in the fields BEFORE UPDATE event you can check to make sure its valid

Man kan godt bruge dmax i standardværdi i en formular, i hvert fald i AccessXP, men man kan ikke bruge dmax som standardværdi i en tabel.

Så du skal sætte følgende linie ind som standardværdi for det felt i formularen, som har det ønskede felt i tabellen som kontrolelementkilde:

=DMax("mitfelt";"mintabel")+1
mitfelt er feltnavnet i tabellen
mintabel er tabellen

Tak for hjælpen - Thanks for everything !

selv tak :o)