In OS X, I can right-click on an interactive container and choose "Open with Preview." Unfortunately, on other users' machines where Acrobat is installed, "Open" isn't among their options. Another fine reason to stay away from Acrobat, if I may editorialize. I also don't know what options exist in Windows when you right-click.
Anyway, if you can't right-click to open it, the only solution I've seen involves exporting field contents to the temporary path (see Get(TemporaryPath) and using variables in the export path) and including the auto-open option on that export.
The scripted method Dillik describes will open your file with one click and no dialogs as you have specified.