1 Replies - 1517 Views - Last Post: 04 December 2012 - 10:33 PM Rate Topic: -----

#1 jacjacjac  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 5
  • Joined: 02-August 10

VBA how to print a subForm/datasheet or export to a report to print?

Posted 02 December 2012 - 09:33 PM

Hello,

My problem is I have a mainForm with a combo box that acts as a filter for a subForm/datasheet, the results are from a database, so depending on what what was selected, it will dynamically update the subForm/datasheet.

The issue I want is whatever the user selects (and results displayed) I wish to be able to 'print' out the results. The SubForm/datasheet has four columns, ID, FirstName, LastName, DateOfBirth.

Now im unsure of the best way, i thought I might be able to create a button (on the mainForm) that just prints what is displayed in the subForm/datasheet or do i export it to a report, what is the easiest way to print out the results?

With whatever method, what is the process and code? I have googled it for both methds, printing out the datasheet (doesn't seem like i can) or printing a report, i can't seem to manage it with the dynamic contents of the subForm/datasheet.

Thanks in advance,

Jac

Is This A Good Question/Topic? 0
  • +

Replies To: VBA how to print a subForm/datasheet or export to a report to print?

#2 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 571
  • View blog
  • Posts: 2,979
  • Joined: 19-May 09

Re: VBA how to print a subForm/datasheet or export to a report to print?

Posted 04 December 2012 - 10:33 PM

I assume you're using Access. Focus on using a report, and tell us more about your attempts to "manage it."
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1