I don't understand this error message

[aoswald]

"The method you tried to invoke on an object failed"
*You may have specified too many or too few arguments for a property or method of an object. Check the component's documentation for information on the properties and methods it makes available for Automation operations
*There may not be enough memeory to run the procedure. Close unneeded programs and try to run the proceddure again. For more informatin on freeing memory, search the Micorosft Windows Help index for "memory, troubleshooting".

All I did was right click on a field and selected the Equals (what ever was in the field) I got the error and then it sorted the DB anyway. So it worked but why am I getting this message?

thanks

 

[Rabbie]

It would be helpful if you can give us a little more information.

Which version of Access?
What were you actually trying to do?
What actually happened?

 

[aoswald]

2007

I right clicked on the field and selected Equals(the value in the field)

I wanted all the records with that value in the field


I get the same error no matter which field I try to sort on