Hi All,
Access newbie here.
I currently have a listbox that contains drug names where I manually inputted the names in 'Edit List Items' in its Row Source. On Click, I have a code where it searches for the drug name chosen in the list-box using the LIKE operator so it searches for reports/publications/results that contain the drug name in the respective column, Reference Citation, that I called it for.
Code:
Private Sub ListInd_Click()
Dim myList2 As String
myList2 = "SELECT * FROM [Publications] WHERE ([Reference Citation] LIKE '*" & Me.ListInd & "*')" _
& "ORDER BY [Publications].[Pub Year] DESC; "
Me.subPublications2.Form.RecordSource = myList2
Me.subPublications2.Form.Requery
applyFilt
End Sub
I have switched the Multi Select field in Form Properties to 'Simple' and/or 'Extended, but nothing seems to work. I cant seem to get the multiselect option to work where I can choose more than one option.
Any suggestions?
Thanks