Filtering queries

[NUWildcat]

Is there any way that you can have a query that prompts for a filtering criteria, but instead of having that criteria be for just one of your fields, have the criteria be a string that could include a criteria for anywhere from one to all of the fields? i.e [Name] = 'XXX' and [Job] = True or [School] = True

 

[Pat Hartman]

No, it is not possible to change the structure of a query by passing it a parameter. You can do this by using a form and allowing the user to enter his criteria in an unbound text field. You would then have a button to run the query and in the click event of the button, you would build the SQL string and run it.

 

[NUWildcat]

So is the form than connected to that query when you first create it? Or else how do you get the information into the form that you want to be filtered? Sorry if this question is juvenille, I'm just not very accustomed to Access and if you could walk me through it, it owuld be great. Ive already found a way to create my string now I just need to apply it.
Thanks!