Arthur Fuller
fuller.artful at gmail.com
Fri Sep 7 12:49:38 CDT 2007
The table of interest contains a column called Marked, and various controls to mark rows for inclusion (i.e. age = 12, mark all, then status = 'Inquiry', mark all, then Find Marked which shows the sum of both sets. Then a button invokes a report preview, and its code says: DoCmd.OpenReport ReportName:="RiderList_rpt", View:=acPreview, WhereCondition:="[Marked]= " & True And I get an input box asking me for a value for Marked. If I type in True or -1 the report works. If I type in nothing it displays zero rows. I have tried several variants of this command, such as: DoCmd.OpenReport ReportName:="RiderList_rpt", View:=acPreview, WhereCondition:="Marked = " & True DoCmd.OpenReport ReportName:="RiderList_rpt", View:=acPreview, WhereCondition:="[Riders].[Marked] = " & True DoCmd.OpenReport ReportName:="RiderList_rpt", View:=acPreview, WhereCondition:="[Riders].[Marked] = True" And so on. Nothing seems to prevent invocation of the inputbox asking for a parameter value for Marked. I don't understand what I'm doing wrong. The report in question simply looks for Marked = True. It's not based on a query or anything. It just looks at the one table. The filter "Marked = True" is passed in as indicated above, but it doesn't seem to work. Any suggestions? TIA, Arthur