Most current auto focus lenses can be turned off to be manual focus only. Or some lenses are auto focus with full time manual focus, which means that once autofocus is acheived you can still tweak it a bit by turning the barrel of the lens. Many Canon L series lenses work this way.

Dennis