My mother and I found the solution by accident (to tears with onions, of course). Just put them in the refrigerator. I'm serious. I still do that. And I have cried in years. Well, not due to onions, in any event.
Wouldn't work in the slightest. Neither does cutting them under water. Or holding a piece of bread in your mouth. But refrigerating them works like a charm every time.