By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,611 Members | 1,627 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,611 IT Pros & Developers. It's quick & easy.

Printing SubForms

P: n/a
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.

Mar 30 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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...@gmail.com 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.

Mar 30 '07 #2

P: n/a
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, paq...@gmail.com 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.


Mar 30 '07 #3

P: n/a
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" <p...@packairinc.comwrote:
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.

<paq...@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, paq...@gmail.com 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 -

Apr 3 '07 #4

P: n/a
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" <p...@packairinc.comwrote:
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.

<paq...@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, paq...@gmail.com 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 -


Apr 3 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.