topdesk123
Registered User.
- Local time
- Today, 00:41
- Joined
- Mar 28, 2013
- Messages
- 52
Good morning all!
Inherited another old database. There is a form (Projects by Salesperson Parameters) on which exists 6 list boxes (each with multi select set to extended), 2 start and end date groups, and 3 combo boxes. Right now I am just concerning myself with the list boxes (named: Salespeople, manufacturers (mfgs), productgroup, bidders and status.) The report to be opened is "ProjectsbySalesperson", its recordsource is "projectsbysalespersonquery" which contains all of the tables necessary to get the information requested.
I am trying to cobble together a combination of
AND
I'd post the whole mess, but that's all it is, is a mess. Can't quite get my head around it. Since there are 6 different ctl.ItemData(varItem)s, how do I get them to produce the strwhere for my query? Or do I need to filter the report directly? So confused, so Monday. TIA!
Inherited another old database. There is a form (Projects by Salesperson Parameters) on which exists 6 list boxes (each with multi select set to extended), 2 start and end date groups, and 3 combo boxes. Right now I am just concerning myself with the list boxes (named: Salespeople, manufacturers (mfgs), productgroup, bidders and status.) The report to be opened is "ProjectsbySalesperson", its recordsource is "projectsbysalespersonquery" which contains all of the tables necessary to get the information requested.
I am trying to cobble together a combination of
Code:
For Each varItem In ctl.ItemsSelected
strWhere = strWhere & ctl.ItemData(varItem) & ","
Code:
strWhere = strWhere & "([person] = """ & Me.Salespeople & """) AND "
I'd post the whole mess, but that's all it is, is a mess. Can't quite get my head around it. Since there are 6 different ctl.ItemData(varItem)s, how do I get them to produce the strwhere for my query? Or do I need to filter the report directly? So confused, so Monday. TIA!