Hi,

I am doing an insert onto a table in access. I am inserting four fields while the fifth field which is an ID is auto generated. The sql statement is
VB Code:
  1. sql = "INSERT INTO LogTable(Username,[Date],[Time],EditFields) VALUES('" & struser & "','" & Date & "','" & Time & "','New Mailbox " & newmailname & " created');"

Is there a way for me to store the value of the autogenerated id where this insert is being performed, since I need this id value later on.

Thanks