I am trying to use this dlookup as my Control Source for a textbox:
DLookUp("Customer","tblCustomer","Customer_ID = " & [Forms]![frmSellingMain]![tbCustID])
I cannot figure out why it is not working. The syntax looks correct and I checked the spelling over and over.