G
google-post
Is there any way that you can detect that there is an OrderBy error?
I can fix the problem by disabling the ability to order by a
particular field (and can probably fix the error in OrderBy
clause)...but wondered if there was an easy way.
I've tried to catch the "On Error", "On Filter" and "On Apply Filter"
for the form -- but none of them catch the particular error.
What surprises me ... is that the form won't open if I don't clear the
OrderBy. The code never even gets to Form_Open -- so it looks like
there is no way of catching the error on load, if the invalid OrderBy
was applied by the user. Or is there another way to catch the error
on load?
Thanks,
John
I can fix the problem by disabling the ability to order by a
particular field (and can probably fix the error in OrderBy
clause)...but wondered if there was an easy way.
I've tried to catch the "On Error", "On Filter" and "On Apply Filter"
for the form -- but none of them catch the particular error.
What surprises me ... is that the form won't open if I don't clear the
OrderBy. The code never even gets to Form_Open -- so it looks like
there is no way of catching the error on load, if the invalid OrderBy
was applied by the user. Or is there another way to catch the error
on load?
Thanks,
John