Reading Current Record

[Kavy]

Hello, using this method I added a record, but now I want to return the "key" the number access assgins to my record in the first collumn.

The variable I want to retrieve is called donum in my code, and do in the record collumn

<code>
With rstdept
.Addnew
!TAmount = bla
!something = blaaa
.update
End with

donum = rstdept.??????

</code>


Thanks for any help!

 

[SydneyGeek]

Assuming your ID field is DeptID, you could replace this...

<code>donum = rstdept.??????

with

rstdept.MoveLast
</code><code>donum = rstdept.DeptID

Denis
</code>

 

[Kavy]

Thank you, I dont know why, I was struggling to find the syntax for this!

 

[Kavy]

Just for anyone who searches this msg bored, and to make sure I am doing it correct, I replaced the "." with a "!" and it worked