get current record

[rivereridanus]

Hi,



I am having trouble getting the ID of the current record displayed on a form. The code I have written is this:

Dim ProjID As Long
ProjID = Forms![ProjectDetailsAll].CurrentRecord

The problem is that this code returns the record number relative to other records (so, this record is number 2634 of 2634). However, I am trying to get the ID of the record, which is an autonumber and is not the same as the record's order amongst other records. There have been record deletions ahead of this record, so the ID might be 3096 even though CurrentRecord tells me that this record is number 2634. Is there another way of writing this to get what I need?

[pbaldy]

ProjID = Forms![ProjectDetailsAll]!IDFieldName

where IDFieldName is the name of the field.

[rivereridanus]

Thanks, that helps a lot!

[pbaldy]

No problemo!