CurrentRecord to ID

[sapka]

Let's say there is a table of three columns - ID, Name, Surname - where ID is AutoNumber. ID is not displayed on the Form. How can I find ID number for current/selected record?
I can get current record number by Me.CurrentRecord. But I need to convert it to appropriate ID number. How can I do that in VBA?

 

[alansidman]

Create a command button. Attach code to the command button to display the ID in a MsgBox

Private Sub Command0_Click()
MsgBox "ID is" & Me.ID.Value
End Sub

 

[sapka]

Thanks!
It is interesting that even if control ID is not on the Form (I have deleted it), I can still read its value.