you're right, when i said report i meant form. wasn't thinking when i was
typing the question.
OK. So now we have a switchboard that opens a form.
What switchboard?
1) One you created yourself using an unbound form with command
buttons?
If you don't want the form to open in Add or Edit how do you wish to
open it? I suppose Read only.
Change the click event of the command button to:
DoCmd.OpenForm "FormName", , , , acFormReadOnly
2) If you're using that built-in switchboard created by the Access
Switchboard Manager, you'll need to do a bit more work. You can post
back for a how-to, but frankly, in my opinion it's not worth the
effort. Create your own, as above.