Max Wanadoo
max.wanadoo at gmail.com
Fri Sep 11 08:51:02 CDT 2009
Could you try this, perhaps:- sWhere=nz(sWhere,"") DoCmd.OpenReport sObjName, acViewPreview, , sWhere, , strSvcRegion & "~" & strLocality This will ensure that sWhere is not null before the docmd is activated. Max On 9/11/09, RANDALL R ANTHONY <RRANTHON at sentara.com> wrote: > Hi y'all, > I've got a crosstab query that works great. However, I need to pass an > additional parameter (that may or may not be null) and thought I could just > add them to the query grid. This does not work. I'm assuming that it has > something to do with not being part of the columns displayed. What do I > need to do? > > DoCmd.OpenReport sObjName, acViewPreview, , sWhere, , strSvcRegion & "~" & > strLocality > > Is the command, sWhere = "" or 2 > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >