repeated prompting

enigmajl

New member
Local time
Today, 09:43
Joined
Aug 6, 2004
Messages
8
Hi Everyone,

1st, just have to say that this forum is extremely helpful! even for a newbie programmer like me. =)

my question is:
i wish to create a report which shows a summary of the details at he beginning
in fact i have achieved the output i require.
however, i think because of the manner i defined my queries for the subreport, a messgae box prompting my parameters keep appearing.

could someone kindly take a look and help me please? THanks!!!

Report in question is: QueryBySoftware report
Queries involved: Software query and Query 1

upon parameter prompt: type "visio" or "office" 3-4 times. u will see the output

zipped it up and .rar the .mdb file
too big to post here
rar zip downloads: http://www.rarlab.com/download.htm

Thanks guys!
 

Attachments

The problem is that under certain conditions the report needs to run the RecordSource query more than once. When this happens, you are prompted each time the query runs. The way to get around the behaviour is to gather the parameters on a form and then change your query to refer to the form field rather than prompt.

So change the query from
Where SomeField = [enter some value]
to
Where SomeField = Forms!YourFormName!YourControlName
 

Users who are viewing this thread

Back
Top Bottom