Viola!! Thanks pbaldy!
Your suggestion of Forms!frmAIA_WorkloadTrackingLog!cboAMID.Column(1) had me changing my code:
OLD code:
Code:
Dim DLook As Variant
Dim intsearch As Integer
DLook = DLookup("[UserName]", "[tblAIA_STAFFList]", "[AMID]='" & Forms!frmAIA_WorkloadTrackingLog!cboAMID & "'")
MsgBox DLook & " -That's who!"
NEW and working code:
Code:
If fOSUserName() = Me.cboAMID.Column(3) ThenMsgBox "Yes"
Else
MsgBox "No"
End If
Thanks for helping me think this out loud.
Granting rep points to both June7 and pbaldy and marking this as SOLVED.