Report's 1

[UAMI]

Openreport
I have a form where i introduce the parameter's needed for the execution of a report.
However when i do the openreport comand, a new window apear's to obtain the parameter's that i already introduced in my form. I saw in the help that it's possible to put openargs, but i cant's do it function.

stDocName = "MAPA_DET_FUNCAOrpt3"

stWhereCond = "(FACTURAS.ANMEFA>=[Form]![MAPA_DET]![AnoMesDe]) and (FACTURAS.ANMEFA<=[Form]![MAPA_DET]![AnoMesA])"


DoCmd.OpenReport stDocName, acNormal, , , , stWhereCond



Any suggestions????

 

[Frink]

Hallo,

Try:

stWhereCond = "(FACTURAS.ANMEFA>=" & [Form]![MAPA_DET]![AnoMesDe] & ") and (FACTURAS.ANMEFA<=" & [Form]![MAPA_DET]![AnoMesA] & ")"
if FACTURAS.ANMEFA is numeric or
stWhereCond = "(FACTURAS.ANMEFA>=""" & Forms!MAPA_DET!AnoMesDe & """) and (FACTURAS.ANMEFA<=""" & Forms!MAPA_DET!AnoMesA & """)"
if FACTURAS.ANMEFA is text/memo

-Frink