drop down combo box

[rainbows]

i have a combo box that i use to select the criteria ( say 10 possibilities ) that are selected from my status field in my query for my report , is it possible to run the same query when it would just list all the item except for the ones where the status is "completed"

thanks steve

 

[Uncle Gizmo]

I think you need to provide a bit more information!

 

[MajP]

I agree this question is very unclear and open ended. Please provide an example too, describing what you would choose from the combo and what you would like to see happen.

 

[rainbows]

this is the dropdown box that allows me to query any of these items for example if i select returned i get the following . can i get it without using another query and button showing me all the items in the table except for status "completed"

 

[MajP]

If I understand. All the selections work except if you choose "Complete".
I am assuming the query have a control parameter
where Status = Forms![Dialog:RMA]![SomeComboName]

I do not know the rowsource for the combo box and where it pulls the data. If for example it is a value list and you typed in Complete then you could have a spelling issue that you cannot see. Example is
CompIete vs Complete (These look the same but the first is a Capital "i" and not a small "L"). Sometimes you could have space " Complete" vs "Complete". Either case it looks as if you should match, but they are not the same.

Can you provide the SQL for your query and the SQL for the rowsource?

The other thing that could cause this is that you are using table lookups and that could cause all kinds of problems. I would not be able to tell you a fix without looking at the DB.

If you are

The Access Web - The Evils of Lookup Fields in Tables

 

[June7]

An alternative is to not have parameters in query but to apply filter to form or report. Review http://allenbrowne.com/ser-62.html