DoCmd.OpenReport

[ariel81]

hi,

i have a code:

    Dim stDocName As String
    Dim f As Form
    
    Set f = Forms!frmFltQpi

    stDocName = "FLT Report"
    DoCmd.OpenReport stDocName, acPreview, , f.cboFltQpiYear

basically if the value in the f.cboFltQpiYear is 2006 it should print out the rows with "2006" in the table. however it print out not only 2006 but also all the other years in the table. how to select only for year 2006?

 

[boblarson]

Change this:

    Dim stDocName As String
    Dim f As Form
    
    Set f = Forms!frmFltQpi

    stDocName = "FLT Report"
    DoCmd.OpenReport stDocName, acPreview, , f.cboFltQpiYear

to this (if your year is listed as text)

    Dim stDocName As String
    
    stDocName = "FLT Report"
    DoCmd.OpenReport stDocName, acPreview, , "[TypeTheFieldNameInYourReportThatIsTheYear]= '" & Me.cboFltQpiYear & "'"

Be sure to type in your actual field name (keeping the quotes and brackets) into the spot marked "TypeTheFieldNameInYourReportThatIsTheYear"

 

[ariel81]

thank you...
however, my year is listed as number in the table
how shall the syntax be for "number" instead of text?

 

[boblarson]

Same syntax, just remove the single quotes (').