I have a web site www.canam-us-ca.com
The dropdown for Products works Ok from computer. It does not work from my Ipad Pro. Can this be due to Media Queries? If not what else could be problem?
Your site is NOT mobile-friendly, that's for sure. Your drop-menus don't work on touch screen devices because they lack a mouse to hover with. Ideally, this site should be completely re-built responsively, with touch screen & mobile devices in mind.
Adobe abandoned Spry Menus in 2012. Nobody uses them anymore. Your code is outdated. The web standard is HTML5 and has been since 2014. And look at your code errors.
Lots of work ahead. Consider using a responsive framework like Bootstrap or Foundation. It will save you much time with tedious coding.