Query criteria

[SF]

Hi,

I want to export an existing query (Province Name, District name, Commune
Name) based on the selected value in the list box. I create a criteria
string


Dim stgSQL As String
Dim varItem As Variant

gstrQueryFilter = "'"
For Each varItem In Me.listProvince.ItemsSelected
gstrQueryFilter = gstrQueryFilter & Me.listProvince.ItemData(varItem) &
"' OR '"
Next varItem

gstrQueryFilter = "LIKE " & Left(gstrQueryFilter, Len(gstrQueryFilter) - 5)


How can I use the Criteria with query? (in form, docmd.openform
"formname",,,,,)

SF

 

[Guest]

Your code won't work as you hope it will. You could change to create an
expression like "IN ("A","B",...)"

There is a generic multiselect list box function with usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.