HELP!! I am using sql to fill list box matching user input. using like to avoid exact matches. I am only getting empty returns. I have tried every solution I could find online, but nothing seems to produce returns. I should have 4 matches to what I enter, but get blank file.
sql = "SELECT TBLActivities.actDateReceived, TBLActivities.actTypeSupport, TBLActivities.actProviderName," _
& " TBLActivities.actProblem, TBLActivities.actTextStatus, TBLActivities.actComments" _
& " FROM TBLActivities WHERE TBLActivities.actProviderName LIKE '*" & textsearch.Value & "*'"