Hi Megan,
I know this is many moons later, but I ran across this thread while testing out Access Services on SP 2010. I was successful creating a 3-tier form (form, subform, sub-subform) - so I wanted to let you know that it's certainly possible!
Cheers,
John