Access report is opened but not printing as PDF

[Rashima]

Hi,

I have a access DB and there I push a button to create pdf.After pushing this button it checks for all the functions , prepare data and then opens a access report and gives an error open report action was canceled

It worked in the starting but now it gives error every time.then i have to halt macro and print as pdf manually

is here any solution for this ??
thanks in advance

 

[MarcoBechthum]

hi,

you might check your datasource of your report. i had this problem a few times before and when checking my datasource of the report i was using a where condition that refers to a control on a form. when opening the report it also has to open the form to know the variable of the control i was referring to. the code in the form was written in a way that when the report opened the control did not have its variable set at that time so the report gave the error you mentioned.

in short and better english: check you datasource and be sure all where conditions are ok.

good luck