Hi pete there are usually 2 motors for the sun roof, 1 for the tilt and 1 to open it fully. Sounds like the second motor is working hence the click but has become "disengaged" from the drive mechanism. It does mean stripping the roof to find out so good luck.
Bob
September 2008