View Single Post
  #5  
Old March 2nd, 2010, 05:22 AM posted to microsoft.public.access.queries
AMohamadi
external usenet poster
 
Posts: 6
Default Disapearing Query Results!

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

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!

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

Please help me
thanks Sooooooooo!

"John W. Vinson" wrote:

On Sun, 28 Feb 2010 22:13:01 -0800, AMohamadi
wrote:

Hello and Thanks
You are right! I'm seeing Query result in Data Sheet view but i don't want it!
About my program:In short,I want to simulating MS-Excel Filter in MS-Access
and i need to run queries in the background of system so user doesn't need to
see what is happening.It just needs final result!


If you just want the combo box to contain the results of the query, don't
*run* the query at all; instead, set the combo box's Rowsource property to the
SQL string.

--

John W. Vinson [MVP]
.