Recent content by Patfo

I believe i did what is recommended. Still doesn't work. Believe I placed the quote in right places. Could this be related to the string having a comma? for example : 'Doe, John') Set ctl = Me.List4 For Each varItem In ctl.ItemsSelected stLinkCriteriaAMG = stLinkCriteriaAMG & "'" &...

Hello, I have been trying to pass the itemdata result from listbox List4 to the where condition of the query rather than having JohnDoe below. I tried with & stLinkCriteriaAMG. Option Compare Database Option Explicit Private Sub List4_Click() On Error GoTo Err_List4_Click Dim...