Hi,

I have some troubles with code in access vb.

Well, I made it already possible to add new records with textbox and button with the code:
CurrentDb.Execute "INSERT INTO TblOplossingen (Oplossing) VALUES ('" & TypnieuweOplossing.Value & "')"

Now in my TblOplossingen I have the field autonumberfield.
So when I push on the button, the new record will be placed and also a new number in the autonumberfield.
But this is not the only thing I want.

When I push on the button, I want too that the autonumberfield of my new record will be added in another table. And this while the new number of the autonumberfield of my new record is not visible in the form.

Has anybody a solution for that problem?

greetz