:mad: I need some quick help

I have a db with multiple tables. I have 15 queries that look up open audit obsrevations depending on the name.
I'm trying to limit the number of queries that I need to validate. Is there a way to create one query that has a lookup fied or Key word field.

Thanks in advance

-WM

Yes. A parameter query can prompt you for a value when it runs. Another option is for the query to get its variable values from an open form:
1. Select .... From ... Where SomeField = [enter a value];
2. Select .... From ... Where SomeField = Forms!YourForm!SomeField;

Pat
I used you first option it works great but I have one more issue...
The field I'm looking up is a name field. When I enter a value ie (Warner) I get all the audit observations. (perfect)
However some observations are given to multiple people ie (Warner/Cinder). When I run the query I'm missing the rows which contain multiple names.
Can I use a wild card character or
Select...From... Where SomeField = [enter a value] [ / ] to get all the values

-WM

The correct solution to your problem is to fix the table structure to remove the non-atomic attribute that contains a repeating group. When you have a 1-many relationship, the "many" data belongs in a separate table. Search for posts on normalization.

For the time being you can use the Like operator and wildcards to retrieve all entries.

Select...From... Where SomeField Like "*" & [enter a value] & "*"