supress table

[IANGRAND]

When inititating a query, i do not want the new table to appear. Is it possible to supress the table, so that the new data does not pop-up on the screen. I just want it to be discreet?

Cheers

Ian

 

[BNPMike]

I think you need to tell us a bit more about what you are trying to do here. What sort of query? Why is it a new table? In what way is it new data?

 

[IANGRAND]

It is a select query. The query looks up a user defined word, searching through the text string. It then selects any address containing the key word. I have these results lined to a list box, so all addresses appear in a form. However, the addresses also pop up in the table produced from the query and i need to supress this from appearing, because it is really annoying.

Ian

 

[PHV]

What are:
1) the RowSource property of the ListBox
2) the SQL code of the query

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

 

[IANGRAND]

RowSource property:
SELECT [Find UPRN].EpochDescription, [Find UPRN].LandDesc FROM [Find UPRN];

SQL:
SELECT AQMA_ADDRESS_DATA.UPRN, AQMA_ADDRESS_DATA.ADDRESS
FROM AQMA_ADDRESS_DATA
WHERE (((AQMA_ADDRESS_DATA.ADDRESS) Like "*" & [Forms]![IANS_FORM]![Text7] & "*"));

 

[PHV]

Sorry, I quite don't understand your problem.

 

[BNPMike]

It looks like you are connecting the list box to the recordset in entirely the wrong way. The datasheet should not appear. Have you done this sort of thing before?