I have looked at this code 1000 times and cannot discern why I am getting the error. My table has both fields I am referencing to defined as a long integer. The form returns a whole number every time.
Thank you for your help in advance!Code:Dim varDenSelect Dim varOfferID varOfferID = Forms![frmNon-Corpofferinformation].OfferID.Value varDenSelect = DLookup("[DenSelect]", "DenialReason", "[OfferID] = '" & varOfferID & "'") frameDenialOptions.Value = varDenSelect