Access asks for a value - why?

[systematic]

Hi all,

I have listbox based on a query and a textbox. When the user keys any value into the searchbox, the results of the query filter based on the value using a 'LIKE' query. I have been using this successfully to filter information based on either the first name or surname of clients.

I decided to add searching by full name. I built a simple expression in my query for strName -

strName: [FirstName] & " " & [Surname]

When I open the query, this displays the desired result - but when it is opened it also now prompts me for a 'strName' value.

Can anyone tell me why this is - and what I can do stop it prompting - as when the form is opened it asks me for this, and whenever a value is typed into the text box it requeries - also calling this dialogue.

Thanks

Robert

 

[namliam]

Are you using the strName anywhere else? Just on this it doesnt seem to be logical anyway else.... Can you post the full SQL?