Using F2 on a dropdown list component that is a list source from a View is not finding the value but also clearing the list and cannot be refreshed to show list again.
The IDO Collection is a View that contains all of the properties required.
The RightClick Menu is StdDefault
It is being filtered on properties of the Collection.
It is being OrderBy a concatenated field built on 3 fields of Doc/Rev/Date.
The error is “Incorrect syntax near the keyword ‘Order’”.
If we remove the OrderBy from this field, then the error is “Incorrect syntax near the keyword ‘SET’”.
I have tried creating an Event to Launch the form it is based on to find the value, but that is also unsuccessful.
Any suggestions?