Search>check box (1 Viewer)

[rio]

I have a Table like Table.jpg and then I make form like Form.jpg.
Can anyone help me how to make a search using check box. For example : If I check the soccer and badminton check box, it will show the name with that criteria in list box.

here I attach the image and database....

 

[John Big Booty]

Have a look at the changes I've made to your query.

On a side note avoid using spaces and other special characters in your control and object names as these will cause you no end of grief in the future. You might also like to consider implementing a naming convention, to name your DB Objects. So you don't end up with a table a form a query and a report all with the same name. Something like FRM_FromName, TBL_TableName, QRY_QueryName, RPT_ReprotName, is good.

 

[rio]

Have a look at the changes I've made to your query.

On a side note avoid using spaces and other special characters in your control and object names as these will cause you no end of grief in the future. You might also like to consider implementing a naming convention, to name your DB Objects. So you don't end up with a table a form a query and a report all with the same name. Something like FRM_FromName, TBL_TableName, QRY_QueryName, RPT_ReprotName, is good.

Thanks for ur help and advice.

 

[rio]

I'm make a little change to the db...
New question!! following my selection (check box), can i make it to list down the first name in the list box. no need to open FRM_SearchResult form.
Hopefully u understand my English.

 

[John Big Booty]

OK I think it's doing what you want now.

What I've done is to make the search query the control source for the List box. Then I've put some code in the On Click events of each of the check boxes to requery the list box when ever one of the boxes is clicked. You seemed to have missed part of the criteria in the query when you re-created it.

 

[rio]

OK I think it's doing what you want now.

What I've done is to make the search query the control source for the List box. Then I've put some code in the On Click events of each of the check boxes to requery the list box when ever one of the boxes is clicked. You seemed to have missed part of the criteria in the query when you re-created it.

OK.. now i understand how it's work. Thanks again 4 ur help.

 

[John Big Booty]

Excellent have fun with it.