Helpfulbox Now Offers Free POS Software for restaurants, kiosk, and any other retails business completely free used windows cashier system or as full blown POS. You will able to print to kitchen, display orders on the kitchen screen, manage inventory, employee, report, customer loyalty offers, employee management, delivery address track and much more, al for free.

How do you write code for multiple LIst Box choices

I have created a report that the user wants to pull only specific records. I did this using List boxes because the wanted to make multiple choices. How do I pull this Code together. I've included the fcode used for the first option: For Each item In Me.List58.ItemsSelected If Len(listboxitem) >= 0 Then listboxitem = """" & Me.List58.ItemData(item) & """" Else listboxitem = listboxitem & "," & """" & Me.List58.ItemData(item) & """" End If Next If Not IsEmpty(listboxitem) Then strWhere = strWhere & " And Tbl_Reimbursables_test.Site In (" & listboxitem & ")" DoCmd.OpenReport "ERP_Reimbursables_new", acViewPreview, "", strWhere DoCmd.Close acForm, "Frm_Upload_Reimbursable_File2" DoCmd.Close acForm, "FrmReportSelection2" End If End Sub
By: Guest
Date: Thu-Feb-18-2016-
Response
0
It has been a long time since I used Access so my brain cells are dead; However, I discovered this site online that maybe some interested to you.

Access Tips
Making Sense of List Boxes
http://www.fontstuff.com/access/acctut11...

copy and paste the link in your browser
[d] By: Guest
Date: Thu-Feb-18-2016
Response
What is 1 + 100



Helpfulbox Now Offers Free POS Software

for restaurants, kiosk, and any other retails business completely free. It can be used as windows cashier system or as full blown POS. You will able to print to kitchen, display orders on the kitchen screen, manage inventory, employee, report, customer loyalty offers, employee management, delivery address track and much more, all for free.

Just Updated::