Tilføje nye data i sub-form

fastwrite> Why do you use the same tabel in the subform?
Normally subs forms are used for related records in another table. For example: You would have your order header inthe main form and the details which are in another table in the sub form!

Think about it!
You have an ID in the main form = 10 and because the sub form is related (linket) by the ID then the record in the sub form must also have an ID = 10. But if you try and add another record in the sub form then it gets and ID > 10 !!!! SEEEeeeeee....

YES, SII, DAA, JA!! JEg kan godt se det, men mit hoved er ved at sprænge i luften på grund af larmen på mit arbejde (håndværkere igang, da vi er flyttet etage)

Så jeg opretter en anden tabel, men auto-nummereringen skal være ens på de to, for at kunne linke, right?

I would think so, but as I dont know what your working on then I dont know.
You have an auto number in the main table and MAYBE an autonumber in the other table. But you also have a field in the other tabel which contains the value of the autonumber in th emain table.
For example:
Order number = 1 (autonumber)

Detail Autonumber = 20 (but this is NOT important
Detail ForeignKey = 1 (this refers to Order = 1)

So it is these two fields that contain the same value. OrderNumber and ForeignKey

Nå, jeg fandt jo selv ud af det (nu er håndværkerne også holdt op med at larme :o)

Men tak for din hurtige respons, Terry!!!!

Ej - du får pointene alligevel... skriv et svar, som jeg forstår - og du får lige pointene...

(jeg er så gavmild idag)

svar :)

Måske du lige vil hjælpe mig en ekstra gang.

I min formular (f-01) har jeg en ubound der hedder SendtMail - med en Me.sendtmail = now()
I min sub-form har jeg også en sendtmail - men hvordan får jeg opdateret den, når det er i min f-01 jeg har knappen der aktiverer Me.sendtmail = now() ?

why have two fields doing the same?

If your button is on the main form then use the main forms me.sendmail in the mail!!!