I add a printing button in a form to print the related field in a report. I add VAB code shows below:

    Dim stDocName As String
    Dim strFilter As String

    stDocName = "RPT Order"

    strFilter = "OrderID = Forms![FRM Order New]!OrderID"
    DoCmd.OpenReport strDocName, acViewNormal, , strFilter
but when I clink on printing button, it give me "The action or method requires a report name argument"
I have no ideal about that. can someone help me? Thanks

It looks like the name of the variable you are using is different stDocName and strDocName. Changing one should fix your problem.

A really good way of avoiding problems like this is to put Option Explicit at the top of the code module. This forces you to declare all variables before you can use them. It has saved me a bunch of headaches, and helps your code be better structured.

HTH

Mike

Mike
EchoVue.com

I'm so careless. I solve the problem. thans a lot!

No worries - That Option Explicit helps out a lot, and sometimes you just need a fresh pair of eyes to look at it.

Mike

Mike
EchoVue.com