Query Prompts User Multiple Times for the Same [] info

[JeffTax]

Hello,

I'm writing a simple three line MS Access query that uses the INSTR function and prompts the user for any word they want to search for in a field. The problem is that when I run the query sometimes the same prompt appears more than once and in some cases up to four times.

Any ideas why this happens? See sample SQL code below:

SELECT Table1.NAME, Table1.ACCT, Table1.DESCRIPTION
FROM Table1
WHERE (((InStr([Table1].[NAME],[whatName]))>0));

 

[lespaul]

where are you running the query from? A form? report?

Leslie

 

[JeffTax]

Thanks for the help Leslie.

Right now the query is simply being run by clicking on the query from the list of queries in MS Access pane. (I.E. From the same pane where you design new queries)

Any ideas? Is it a bug?