Mr Retirement
New Member
- Joined
- Nov 12, 2016
- Messages
- 46
Hello!
Hoping this is a simple question. Is there a way to display the ID (primary key, just the default autonumber) of a Record entry on a form in a textbox?
I am currently able to display the Record Number with the following code which works great but i'm looking for the Primary ID also:
Is there something similar to capture the Primary ID?
Thanks,
Mr R.
Hoping this is a simple question. Is there a way to display the ID (primary key, just the default autonumber) of a Record entry on a form in a textbox?
I am currently able to display the Record Number with the following code which works great but i'm looking for the Primary ID also:
VBA Code:
Private Sub Form_Current()
Me.TXTRecordNumber = Form.CurrentRecord
End Sub
Is there something similar to capture the Primary ID?
Thanks,
Mr R.