How to filter/search using a forum?

[MediaCo]

Hi, I have access 2010 and I have built a database to manage actors with fields based on their appearance:



Here is a screenshot (http://i.imgur.com/27E6h.png)

Now, what I want to do is make search forum so anyone can search/filter out the database based on the characteristics they are looking for. For example

Show all white males with blue eyes.

And access would filter out all the entrances that do not meet the criteria and only show the ones that match.

How would I go about doing that? Is that possible?

Thanks in advance
-Vincent

[boblarson]

Vincent:

1. Just a note for you - it is FORM not Forum. A Forum is where you have posted this question a FORM is what you have in your database.

2. You can use what's called FILTER BY FORM and if you create a button you can select Apply Form Filter and then you can copy that button and paste it. Then you can go to the click event and edit the embedded macro behind it. For the first one, you can edit the macro so the action is not ApplyFilter but instead select FILTER BY FORM. Then

3. Change the second one's embedded macro to select APPLY FILTER/SORT and there you have it, a form that can filter right there on your current form.

[MediaCo]

Vincent:

1. Just a note for you - it is FORM not Forum. A Forum is where you have posted this question a FORM is what you have in your database.

2. You can use what's called FILTER BY FORM and if you create a button you can select Apply Form Filter and then you can copy that button and paste it. Then you can go to the click event and edit the embedded macro behind it. For the first one, you can edit the macro so the action is not ApplyFilter but instead select FILTER BY FORM. Then

3. Change the second one's embedded macro to select APPLY FILTER/SORT and there you have it, a form that can filter right there on your current form.

Thank you for our reply, I'll give it a try and report back.

[MediaCo]

All good. Thank you very much.