query results

[IANGRAND]

When you run a select query, the results pop up in a table format. Is there a way of supressing this, so that the results don't pop up?

Cheers

Ian Grand

 

[PHV]

How do you run the query ?
What do you want to do ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[IANGRAND]

I run the query through a form,

the user inputs a key word, in this instance part of their address. Then running the query searched an address database and brings all relevant addresses into a list box, but then the results also appear in the pop up table for the select query. It is this that i want to supress. The only place i want the results to appear in is the list box. i don't want the user to have to remove the pop up box to see the form.

Ian

 

[PHV]

So don't launch the query but modify the RowSource of the ListBox.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[IANGRAND]

How?