disabling criteria prompts (1 Viewer)

i have a report that can be called from 2 forms. it requires two values from each form.

it worked perfectly previously.

now whenever i try to call a report, it the querry for the report is prompting for all the criteria values specified in the query. Previously, its just get the values from the form and run the report, now its prompting for values for the form calling the report, as well as the form that isnt calling the report.

i hope ive sufficiently explained my issue.
my question now is how can i avoid all those prompts ??

my reports still work and display all the correct information after pressing OK on all prompts, i just dont want all the prompts coming up.

??? What has changed? You say it worked Previously --previously to what?

you need that the two form be open to run the report otherwise you must out code on the open event of the report and check whether those forms are open and set the default parameter when their not. then you set the reports recordsource.

nothing changed. i was away for 3 weeks and i returned and resumed working on my project.

when i said it worked previously ... i meant that it worked without showing the prompts. i changed nothing. i even reverted to the working version i had sent my instructor.

now its prompting me. Both versions are prompting me.

frmAddNewPartner and frmAdminPartner are my two forms. they call the same report to display the same information.

the report needs two values PartnerID & CustomerID.

each form provides both values. when im using frmAddNewPartner it keeps asking for values from frmAdminPartner and vice versa.

arnelgp my boss .... "you need that the two form be open to run the report otherwise you must out code on the open event of the report and check whether those forms are open and set the default parameter when their not. then you set the reports recordsource." ???

clueless as to what u mean ... can u speak english bruh ? my project is set up that only one form at a time can be opened.

no, i only speak martian.

"...out code on the open event of the report and check whether those forms are open and set the default parameter when their not. then you set the reports recordsource. " im not sure how to do this .... point me to an example or something to use as a guide please.

im baffled becuz it worked perfectly before now man.

figured out what u meant, found the On Open event for report, (didnt even kno u could code a report), now im trying to ascertain how to identify the open form, any help in this regard ?

Rather than having the report attempt to figure out what form opened it, why not use the WHERE argument of the OpenReport method. That way, it doesn't matter what form opens the report since the criteria is applied by Access directly.