Form Prints Instead of Report

[austin3515]

Button on form opens report in print preview. I've tried everything, including docmd.selectobject "report." But most of the time, the form that includes button will print when I click the printer icon located on the ribbon- NOT the report.

I even tried hiding the form when the report is open. I tried acdialogue setting when report is open (that didn;t work because there was no pritner icon available on the "pop-up window." I tried setting the report to Modal. I tried creating a brand new report with some simple data to see if it was my report, but the same behavior appeared. And lastly I imported all objects into a new database to see if that would help. It did not.

What the heck is going on? I've done no less than hundreds of reports and never had this issue, ever. I had read somewhere that an "on timer" event will constantly cause the report to lose focus, but I do not have one of those.

 

[strive4peace]

is the form with the button in dialog mode? Keep in mind there can be only one ...

 

[austin3515]

No, it's not. The form in question is opened when I open the database because under database options, current database, I have selected it as the start-up form. This is Access 2013 by the way (I think I forgot to mention that).

 

[austin3515]

I do have a bunch of code on Load, SQL updates etc. Could that be doing it? Would it help if I changed FormA o m start up form and had all my ode run when it was opened, and then after th code finshed executing opened my true main form.

On the open event I a tuning eho on and off.

The typig on this site is bruta. Anon haeay tips?

 

[austin3515]

OK, regarding the typing it looks like compatability mode might have helped.

 

[strive4peace]

Great! Perhaps you can explain so others can benefit too? thanks ~

 

[austin3515]

Still have the same problem with Access and this darn report not printing. I was having a lot of trouble typing on this website, but it seemed like switching to compatability view helped.

 

[strive4peace]

sorry you are still having problems

please post all the code behind the form -- and remember to wrap it with CODE tags (highlight your code and click the # icon above the message window)

please also post the code that opens your form

thank you