I'm using FancyPrarie's BuildWhere module to generate a dynamic report from a single form. Everything works fine if I use Text Boxes. I have the following fields:
txtLaborDate_BeginR
Tag = Where=LaborMain.ClockInDat,Date;
txtLaborDate_EndR
Tag =
txtGroup
Tag = Where=LaborMain.Group,String;
txtOperation
Tag = Where=LaborMain.Operation,String;
Now these work great but when I change the Group and Operation TextBoxes to ComboBoxes based on queries, I get the following error when I hit the report button:
Run-time error '3075:
Missing ),], or Item in query expression '( (LaborMain.ClockInDat Between #11/1/2004 AND #11/12/2004 23:59:59#) AND (LaborMain.Group In('SILO', )'.
If I leave the comboboxes empty the report will generate without errors but includes all groups and operations.
I think an adjustment is needed to the Where= tag but I've tried adding ,Like and ,= after String but I get the same error either way.
Thanks for any help!
txtLaborDate_BeginR
Tag = Where=LaborMain.ClockInDat,Date;
txtLaborDate_EndR
Tag =
txtGroup
Tag = Where=LaborMain.Group,String;
txtOperation
Tag = Where=LaborMain.Operation,String;
Now these work great but when I change the Group and Operation TextBoxes to ComboBoxes based on queries, I get the following error when I hit the report button:
Run-time error '3075:
Missing ),], or Item in query expression '( (LaborMain.ClockInDat Between #11/1/2004 AND #11/12/2004 23:59:59#) AND (LaborMain.Group In('SILO', )'.
If I leave the comboboxes empty the report will generate without errors but includes all groups and operations.
I think an adjustment is needed to the Where= tag but I've tried adding ,Like and ,= after String but I get the same error either way.
Thanks for any help!