Detect OrderBy error in Access97?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top