Full Version: Multi-select listbox to create report & date
UtterAccess Forums > Microsoft® Access > Access Forms
I've got a form that can select items on a multi select what I'd also like it to do is pick the selected type and select only these between certain dates. The current code I'm using to select the items is as follows.
trWhere = strWhere & "item_Type In("
For Each varItem In Me![itemtype].ItemsSelected
strWhere = strWhere & """" & Me![itemtype].Column(0, varItem) & ""","
Next varItem
' Replace the trailing comma with closing parens
Mid$(strWhere, Len(strWhere), 1) = ")"""
DoCmd.OpenReport "orders", acViewPreview, , strWhere
I have also added two date boxes on the form for the start and end dates required called D1 and D2. Can anyone help me with this
I've manhged to get it working now
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.