Why wrong?

Private Sub Voeg_nieuwe_oplossing_toe_Click()

CurrentDb.Execute "INSERT INTO TblOplossingen (Oplossing) VALUES ('" & TypnieuweOplossing.Value & "')"

IDMAX = "Select MAX ID from TblOplossingen"
CurrentDb.Execute "INSERT INTO TblKruis (IDFout, IDOplossing) VALUES ('" & KiesFout.Value & "', '" & IDMAX.Value & "')"

End Sub


The IDMAX is the autonumberfield in a table.

greetz

Try..

IDMAX = "Select MAX(ID) from TblOplossingen"

or

IDMAX = DMax("ID","TblOplossingen")

VBdebugger says the fault lies in:

CurrentDb.Execute "INSERT INTO TblKruis (IDFout, IDOplossing) VALUES ('" & KiesFout.Value & "', '" & IDMAX.Value & "')"

I would think instead of Value something else but i don't know what exactly.

greetz

"The IDMAX is the autonumberfield in a table." -- no it isn't.... it's a text string. You're setting it to a SELECT, but you never execute it or anything. Then in the very next line, you try to use like it's a recordset or something.

Tg

Is it possible to add?