Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FancyPrarie's BuildWhere Form - ComboBoxes?

Status
Not open for further replies.

DBLoser

MIS
Apr 7, 2004
92
US
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top