Thank you both! I should have read the post first.
It works a treat on my D200. I guess I was looking for a Prime with a wide aperture and AF for the D40. The D40 is so much more convenient to carry around for casual photography.
I actually don't mind focusing manually too much - I had to learn as I recently invested in a 50mm f1.2 for the D200.
I can see there are lots of decent AF-S lenses on ebay. I am after prime really as I love the optics with these.
However the reviews for the Nikon Nikkor AF-S G ED VR 24-120mm Lens are okayish ... its not everyones favourite lens. I have my eye on one on ebay. But as a general purpose lens it should be OK I guess. Any opinions on this lens?