Getting unique ID after INSERT 1

[Jarod81]

In Access, is there a way to get the primary key of a record that I just used an SQL INSERT INTO statement on?

What I'm trying to do is create a record in a parent table, then create several records in a child table (one-to-many). Right now, I'm using two seperate INSERT statements, but to do the second I need the primary key from the parent record. Or is there an easier way to do this?

 

[Remou]

How about:

strSQL = "Insert Into T (Notes) Values ('abc')"
CurrentDb.Execute strSQL
strSQL = "Select @@identity From T"
Set rs = CurrentDb.OpenRecordset(strSQL)
Debug.Print rs.Fields(0)