I saw the movie this weekend. I liked it. If you didn't see Casino Royale, you might have been lost... It is a continuation of the story line of that movie.
Several shots of the R-9, including the "disassembly" scene. (I wonder if she was using a disassembly tool?)
None are so good that a casual observer would definitely make out the gun I don't think -- but very cool nonetheless. And -- the villan is killed with a single round from the R-9!
Something about the movie--the way it cuts quickly from scene to scene--make the movie seem very fast paced and frantic, but isn't good for identifying guns in the movie!
I hope we see the R-9 in the next movie too. Its time for Bond to ditch that silly PPK!