AnyLookup() is another function that I have been testing.
I have a test setup, so field names do not always match data I am looking up, but the field type is always correct, ie text.
I am getting differing results with this. Some forms the lookup works exactly as expected, including either using fixed formnames ("ADV_Session") or looking up the same value from a field, either typed in or derived. Other forms, it does not matter how I set it up, it just refuses to return data.
One example I have used that works
AnyLookUp(Concat(COUN_LookupForm1,"?Disp_Counter=",COUN_Counter," "), "DISP_Address1")
AnyLookUp(Concat("ADV_WealdenDisplays","?Disp_Counter=","10001234"," "), "DISP_Address1")
Another that refuses to work:
AnyLookUp(Concat("CRM_CustomerFile" ,"?CUST_Unique=","Weald53322"," "),"CUST_Company")
There are several of these that work and several that don't, so it isn't isolated. On the ones that dont work, I have systematically gone through the various permutations of fixed data values and field data values, and am fairly sure it isnt just a simple syntax error (although some of the tests I have done, there ARE syntax errors which get highlighted)
Is there some form of limitation on forms that could be stopping these working? Am I missing something on the formulae that needs to be there?