"o" is ussually followed by locative case. (always when meaning "about")

The main meaning of "o" is "about", and then you use Locative: "O czym śpiewasz?"

There are other meanings which use Accusative, and at least some of them could be translated as "for", like "What are you asking for?" = "O co prosisz?"