Urgent: Mutliple prompting of parameters on Access page

[s2230011]

Hi all,

I am just newbie to access but it got pushed onto me at work for some urgently needed work.

My problem is that I have a query that prompts the user to search a field of the database for a certain string. Everything worked fine, until I put a serverfilter hyperlink in the results bought back( to open up the record in more details). The page now prompts me twice for the string everytime. If I remove the serverfilter string, it works fine again

I have looked everywhere online, but cant find an answer. I really hope someone can assist me as soon as possible.

Much appreciated.

John

[Stewart Ross]

Could you post the SQL for your query, please? Without seeing it there is too little detail for us to guess what might be wrong.

Thanks

Stewart

[s2230011]

Thanks for your reply, the query is:

ALTER PROCEDURE QuerySoftware

(
@Software_you_w ould_like_to_se arch_for nvarchar(150)
)

AS
/* SET NOCOUNT ON */
Select * from pcaudit
where displayname like '%'+ @Software_you_w ould_like_to_se arch_for +'%'
RETURN

[s2230011]

I am not sure how can a simple query like this would cause a problem ?

Select * from pcaudit
where displayname like '%'+ @Software_you_w ould_like_to_se arch_for +'%'

[s2230011]

Anyone at all ?!?!?