Printing SubForms

[paquer]

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.

[paquer]

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, [e-mail] wrote:

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.

[paii, Ron]

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.

<pa****@gmail.comwrote in message
news:11**********************@p15g2000hsd.googlegr oups.com...

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, [e-mail] wrote:

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.

[paquer]

Can Grow works fine if the partticular record you want to print
happens to be first in the list. If you want the second record you
cant get it individually.

acSelection prints the Current "Main Form" & all it Sub Records.
How to I get it to print only the active 'Main' & 'Subform' records.
On Mar 30, 2:24 pm, "paii, Ron" <[e-mail]:

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.

<[e-mail] in message

news:11**********************@p15g2000hsd.googlegr oups.com...

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, [e-mail] wrote:

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.- Hide quoted text -

- Show quoted text -

[paii, Ron]

You will need to identify the visible sub form records, then adjust your sub
form's source query to show only those records. As for identifying the
visible sub form records someone else may need to help you.

<pa****@gmail.comwrote in message
news:11*********************@w1g2000hsg.googlegrou ps.com...

Can Grow works fine if the partticular record you want to print
happens to be first in the list. If you want the second record you
cant get it individually.

acSelection prints the Current "Main Form" & all it Sub Records.
How to I get it to print only the active 'Main' & 'Subform' records.
On Mar 30, 2:24 pm, "paii, Ron" <[e-mail]:

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.

<[e-mail] in message

news:11**********************@p15g2000hsd.googlegr oups.com...

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, [e-mail] wrote:
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.- Hide quoted text -

- Show quoted text -