Hi guys,
When using Edit Form, lets say the Data source is Contacts, if in its "Item" property we put a lookup formula, ain't it will show blank if the lookup cannot find the condition ?
My lookup is simply like this :
LookUp(Contacts, Contact = varContact)
My issue is when it is cannot find (because the variable empty), when I run the app, the form will throw message "Getting your data" with no end. I tried to put some If condition and when it is not meet, no need to go to that lookup and use Blank() function also not working.
Any idea why ? It is a Custom Page though.
Thanks