Solved MS Access print form instead of report

[Akai90]

hai

i have problem sometime my print preview report will print form not a report. print preview show report but it will print forms not report (sometime will print report but sometime will print forms)..
can i know what the problem ? any wrong setting ?

report call via button from forms
button using marco setting

 

[Akai90]

Remove the macro and do it with VBA. It only takes one command:

DoCmd.OpenReport "xxx".......

Access will help you with intellisense to complete the string.

TQ for the reply.

 

[Akai90]

Remove the macro and do it with VBA. It only takes one command:

DoCmd.OpenReport "xxx".......

Access will help you with intellisense to complete the string.

already try this code but.. it will direct print the report.
i want open the print preview first to check all data is correct.

 

[arnelgp]

you are "missing" additional parameter:

docmd.OpenReport "report_name", acViewPreview