vba - How To Output access Report with Condition -
vba - How To Output access Report with Condition - good day dears i have form run study status when run form filter(condition) work correctly report but when create pdf( docmd.outputto) pdf homecoming value (the filter or status don't work). this code fsetaccesswindow (2) docmd.openreport "report1", acviewreport, _ "select * main id '" & nz(me.cmrtxt, "*") & "' , place_of_discharge_ar '" & nz(me.dischargecombo, "*") & "' , border '" & nz(me.bordercombo, "*") & "' , a_date between " & _ format(nz(me.statrdatetxt, "01/01/1900"), "\#mm\/dd\/yyyy\#") & " , " & _ format(nz(me.enddatetxt, "01/01/2900"), "\#mm\/dd\/yyyy\#"), , acdialog me.visible = true docmd.outputto acoutputreport, "report1&