Search results

Hi Shoji...By changing the bound column from 1 to 2. Yes it works!! Thanks a million. Thank you so much :D

Thanks shoji but still.. :( I chose 2 sports and this shows but still no result. [Sports]='1' OR [Sports]='6'I chose 3 sports and this shows but still no result. [Sports]='1' OR [Sports]='6' OR [Sports]='7'FirstName and LastName are still showing results. Below are the full codes for...

Well now there isn't any error but after trying out .... 1) choosing the multiselect eg. a)choosing 2 sports..no result... b)choosing 2 school..no results 2) there are results if i were to key in firstname or lastname though... what do you think cause this empty results?

Hi Shoji..Thanks for the code.. but now I've got an error msg. Run-time error '424' Object required Pointing to this lines of codes strTemp = strTemp & " OR Instr(1, [" & strTargetField & "], '" & _ ctl.ItemData(varItem) & "') > 0"What seems to cause the issue.. I'm unable to...

Hi Guys...let me elaborate further.. I have 2 additional tables and 1 more form. tblSports Badminton Baseball Bowling Canoeing Rugby Soccer Tennis tblSchool All Blacks School All Star School Liverpool Sports School...

Hi Gasman..Yah I saw this page before though. The thing is.. this code is for a search form that consist only multiselect listbox. Now I have textbox as well. How am I going to incorporate all in? Thanks :D

Hi all. I have created a multi field search form that have 2 textbox and 2 multiselect listbox(extended). How to make the search form query correctly? Below are the details. Thanks Form frmSearchForm 2 textbox and 2 multiselect listbox Textbox 1 > txtFirstName Textbox 2 > txtLastName...