Tags: access, along, database, field, formi, microsoft, mysql, oracle, print, printing, printout, sql, subform, subforms, theinfo, user
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.
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
Private Sub Print_Field_Form_Click()
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:#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
- 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....ms-access.questionfor.info.packairinc.comwrote:Quote: