Save single field in variable

[cybermonkey]

For the ultimate end result, I actually have everything working except for one thing.


I have a form that displays the info of a table, what I need to be able to do is when somebody double clicks a field on that form I need to VBA code that will save the value of the field they double clicked on to be saved in a variable that is defined.
Currently it's saving the value of the field of the very first record of the table, no matter which one I click on.

I am sure it's something simple that I am missing.
Any assistance will be appreciated.

Below is the current code being used:
Dim dbsPhoneL As DAO.Database
Dim rstPubNum As DAO.Recordsets("PhoneList")
Dim PNum As String


Set dbsPhoneL = CurrentDb
Set rstPubNum = CurrentDb.Recordsets




PNum = rstPubNum("Public Number")

[Welshgasman]

I would have thought you'd want something along the lines of

PNum = Me.Whatever the control is called on your form that holds PhoneNumber for that record?

[cybermonkey]

damn it that's it.
I was WAY overthinking it. LOL Thanks.