Hello - this is my current code for a Label. The Status.Value <> "D" part does not appear to be working. I get the delegation error message - and when I put in a value that has a status of D it still returns a result. It should say TIN Not Found
Assuming delegation is the reason why - the list has 27,000 records in it. Looking for suggestions for workarounds.
Thank you
LookUp(
'TIN Crosswalk',
txtTINNew_2.Text = TIN && Status.Value <> "D",
Prov_Acct_ID
),
"TIN NOT FOUND"