Hello there,

These days I cannot solve issue which I am having with access.

The idea is to create a access form with checklist(drop-down-menu) and other values like firstname, lastname, friendlist(dropdownmenu) etc..
Here I want to create a possibility to search with form where I could find a customer on database which is equal to what I choose on form and other values which you click from dropdownmenu.

Example of form:

FirstName
LastName
FriendList(Thomas,Jimmy,Henry,Martin) < valuelist(drowndownmenu) here I could check more than one value

I tried creating a query and on criteria writing :

Like "*" & [Forms]![SearchForm]![FirstName] & "*"
same criteria with Friendlist(drowndown) so it doesn't work this way and database are showing all possible results. I don't know anything about macros(vba).. Can someone help me please? I'm stuck with this project for some time and could find any answer how to complete this search form.