On Mon, 1 Mar 2010 21:22:01 -0800, AMohamadi
wrote:

Unfortunately i need queries result for tow purposes,One for combo boxes data
source and another for next query as input!

There is still NO REASON to "run" the query and open a query datasheet.

The SQL of the second query can reference the name of the first query.

Please pay attention: I have 5 queries and 5 combo boxes,The first combo box
reads RowSource data from a table and after it changes query no.1 runs and
selects specific records from that table that are match in the special field
with combo box no.1,in the next step combo box no.2 gets it's required data
from query no.1 and after it changes,query no.2 runs and selects some records
from query no.1 and so on...... until when query no.5 runs,Job is done and
now at this time user must see final selected records and do some special
works!

That seems to be an extremely convoluted way of doing things but... ok; you
can set the second combo's rowsource in the AfterUpdate event of the first,
and so on.

So i just need to see the results of query no.5!

Then that's the ONLY query that you need to actually open.

--

John W. Vinson [MVP]