dim i as integer RecordSet.AddNew RecordSet!Field1 = "some text" RecordSet.Update i = RecordSet!participant_id"i" is empty but when i go into access i can see that there is a number that has been assigned. how do i find out what id number i just added? i use this value throughout the rest of the application and need it. according to one of my reference books, wrox ado2.6 programmers reference, it should work but i am not using ado2.6. i think my version is ado2.5 library ?? the dll is msado15.dll so i'm not sure but the text that displays the available references says ado 2.5 lib.