Hi All,
I am creating a database for someone - currently it contains members details and has a form displaying this information along with check boxes for various interests they may have.
Now the user may wish to search by a combination of any of these check boxes. A quick search on google suggested a multi choice list box for this.
For example, I might want to view everyone who is interested in sports, gaming, music and film, all of which are check boxes. But another time i may only want to view those interested in sports and gaming. I might also wish to include where abouts the person lives in the search, so the 'Area' field (a text box) would also be selected.
Anyone give me a quick guide (or point me in the direction of one) to enable me to do this?
I've used VBA, but its been a while, so could you be gentle please?
Any help would be much appreciated.
I am creating a database for someone - currently it contains members details and has a form displaying this information along with check boxes for various interests they may have.
Now the user may wish to search by a combination of any of these check boxes. A quick search on google suggested a multi choice list box for this.
For example, I might want to view everyone who is interested in sports, gaming, music and film, all of which are check boxes. But another time i may only want to view those interested in sports and gaming. I might also wish to include where abouts the person lives in the search, so the 'Area' field (a text box) would also be selected.
Anyone give me a quick guide (or point me in the direction of one) to enable me to do this?
I've used VBA, but its been a while, so could you be gentle please?
Any help would be much appreciated.