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")