Filtering records with multiple checkbox in form

[Lennon]

Can anyone tell me how to make a filter in form with multiple checkboxes???

Well, I have a db with surname, name, gender, age.... how to make a form that will show me only the records with selected chexboxes (gender=male, age=10-20....)?


I'm new to this so please help!

 

[vbaInet]

Welcome to the forum!

Search the forum for the keyword "Search form". It's been discussed several times and I know one or two VIPs/Admins that have some tutorials/sample dbs on here.

 

[John Big Booty]

Welcome to the forum!

Search the forum for the keyword "Search form". It's been discussed several times and I know one or two VIPs/Admins that have some tutorials/sample dbs on here.

Speaking of which there is one here it uses radio buttons rather than check boxes but concept is the same.

 

[vbaInet]

Speaking of which there is one here it uses radio buttons rather than check boxes but concept is the same.

I will bookmark this for next time. But make sure you're around to answer any queries.

 

[Lennon]

Thank you all.. You are great...


Well, I have one more question! I managed to filter out results with query expression:

IIf([Forms]![FormChoice]![Gender_M];[Gnder]="M";True)

And so for female....
It works if i select checkbox for male (it show me males), and it works if I select females (it show me only females)

Problem is when I select both females and males. Then it dose not show me anything...

Any help/suggestion?

P.S. Sorry on my english but I'm from croatia and not very good with english!