primary key at add new record time

[elios115]

dear all,

i have a database with 2 tables say tb1 and tb2.
tb1 with primary key tb1ID
tb2 is linked to tb1 with tb1ID

at some point i need to add a record to the table of tb1 using recordset.addnew(VBA)
and assign the primary key of the newly added record to the field tb1Id in tb2 to link them.
but im gettin the error that the tb1ID not found at creation time.

is there anyway to retrieve the newly added primary key and assign it to the field in tb2?



thx hope i ll get some help

[jzwp11]

Here is a code snippet that might help; I use a variable hdpkAddressID to hold the primary key when the record is create.

 With myRSAddress
            .AddNew
            !txtAddress = Me.txtAddress
            !fkStreetTypeID = Me.cboStreet
            !txtApt = Me.txtApt
            !fkCityStateID = Me.cboCity
            !txtZip = Me.txtZip
            hdpkAddressID = !pkAddressID
            .Update
        End With