Hello All,
I'm pretty new to Access and am working on a very simple dlookup. Taking the KAM (persons name) from one table based on a common Customer Name/Sold To into a form that I am creating. Please take a peak at my code below and help me with my error:
Private Sub SoldTo_AfterUpdate()
KAM = DLookup("KAM", "CustomerKam", "CustomerName= 'SoldTo'")
End Sub
I don't get an error AT ALL with this code but it doen't work. If I make the below changes after reading some other threads I get the standard error of 3464ata Type Mismatch
Private Sub SoldTo_AfterUpdate()
KAM = DLookup("KAM", "CustomerKam", "CustomerName=" & SoldTo)
End Sub
I cannot find any documentation on the special characters required for numerics vs text....can anyone provide?
Thank you SO much for your help!
Loni