Geting primary key from newly created record (DAO.Recordset)

  • Thread starter Thread starter Niklas Östergren
  • Start date Start date
N

Niklas Östergren

Hi!

How do I get the primary key from a newly added record in a DAO.Recordset?

TIA!
// Niklas
 
Niklas,

Am I guessing correctly that you are talking of a situation where the PK
field is an autonumber, and the record is added through code? If that's
correct, then the PK autonumber is assigned as soon as you execute
rst.AddNew, so anytime after this and before you move to a new record you
can get the PK value by means of rst.Fields("PKFieldName"). You can do so
even before the rst.Update is executed, it doesn't make a difference. All
that's required is the PK field to be included in the recordset SQL string
(if not a whole table).

HTH,
Nikos
 
Hi!

Thanks a lot, just what I needed to know!

Yes, you where asuming right. I do add the records by code and yes PK is a
autonumber.

Thanks a lot agin! Now I´ll stay at work and work a little bit more on this
before I go home and having anice weekend! :-)

// Niklas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate a primary key!? 1
Is there a way to know where the bookmark in a DAO.recordset is? 7
Retrieving a newly created Primary key 2
Problem with populating an Array! 5
Can't seem to retrieve primary key number of newly created record in VB 1
NotInList updated but not shown on form until close and reopen 12
primary key - concatenated or autonumber? 6
DAO to copy records and sub-records. 1

Back
Top