Tags: access, along, database, field, formi, microsoft, mysql, oracle, print, printing, printout, sql, subform, subforms, theinfo, user

Printing SubForms

On Database » Microsoft Access

12,967 words with 4 Comments; publish: Fri, 04 Jan 2008 14:12:00 GMT; (250156.25, « »)

Hello'

How do I get the subform to print along with the main form?

I want my user's to be able to go in the field with a printout of the

info they need to populate in the database. So when they get back in

the office they can input the data field by field.

The reason I want them to take the actual form & subform is there is

prepopulated data they need in the field.(which is on the form).

& I want the paper version to look exactly like the database version.

All Comments

Leave a comment...

  • 4 Comments
    • Okay, So I got access to do what I want pretty much.

      I created a Command Button to print it all out using the following

      code;

      Private Sub Print_Field_Form_Click()

      DoCmd.Printout acSelection

      End Sub

      This prints out the Master form & subform. Although there are many

      records for the subform, & it is printing out all subform records. I

      want it to print out only the current subform record. How would I

      modify this code to do so?

      On Mar 30, 12:16 pm, paq....ms-access.questionfor.info.gmail.com wrote:

      Quote:
      === Original Words ===

      Hello'

      >

      How do I get the subform to print along with the main form?

      I want my user's to be able to go in the field with a printout of the

      info they need to populate in the database. So when they get back in

      the office they can input the data field by field.

      The reason I want them to take the actual form & subform is there is

      prepopulated data they need in the field.(which is on the form).

      & I want the paper version to look exactly like the database version.

      #1; Fri, 04 Jan 2008 14:14:00 GMT
    • Setting the can grow property of the subform control to "No" will keep the

      form expanding. If you want to show only some subset of records, update the

      subform record source.

      <paquer.ms-access.questionfor.info.gmail.comwrote in message

      news:1175273201.935349.206010.ms-access.questionfor.info.p15g2000hsd.googlegr oups.com...

      Quote:
      === Original Words ===

      Hello'

      How do I get the subform to print along with the main form?

      I want my user's to be able to go in the field with a printout of the

      info they need to populate in the database. So when they get back in

      the office they can input the data field by field.

      The reason I want them to take the actual form & subform is there is

      prepopulated data they need in the field.(which is on the form).

      & I want the paper version to look exactly like the database version.

      >

      >

#2; Fri, 04 Jan 2008 14:15:00 GMT
  • >

    - Show quoted text -

    #3; Fri, 04 Jan 2008 14:16:00 GMT