I want to be able to capture and display the user's sql login name on my form when the user checks a checkbox called "InvestigationComplete" on my form. Is there a way to accomplish this programatically. I have admin writes to Microsoft SQL server. The datasource is "ucrdata" sql table with a field called TestTech that I want to capture this login name.
Private Sub InvestigationComplete_Click()
Me.InvestigationComplete.Value = -1
Me.InvestigationComplete.Locked = True
me.TestTech.Value = ............user's sql login ID............