Query Trouble!

[Chunz]

here's the promt guys. I DONT wanna be prompted for this!

[JoeM]

Switch your query to SQL View, and post the SQL code from that query.

Is the query based on a table or another query?
If it is based on another query, what happens if you open that query directly?
If that other query has a parameter on it, then any query based on it will also have a parameter on it.
You will want to base your new query on a table or query that does not already have a parameter on it.

[June7]

This is one reason I don't use dynamic parameterized queries.

[Chunz]

i used this in the criteria space [Which MARITAL STATUS?]

[JoeM]

That is the problem! That is a Parameter Query which returns the prompts.
See this for more details: http://www.gcflearnfree.org/access2013/20

If you just want to return the Married people with no prompt, replace what you currently have on that Criteria row with "M".

If you are using this other query for other purposes, and want to keep the prompt for those other things, create a second similar query which has the "M" criteria instead of the prompt, and base your other query on this one instead.

[Chunz]

HEY, Thanks Joe!, IT WORKED! ^^

[Chunz]

Thanks Everyone am Prompt Free now, and can enjoy life more, Well done Joe Mate. ^^