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

Printing Forms & Subforms

P: n/a
I have forms that are used in the office as well as in the field.
I want user's to be able to print out an exact copy of the form for
"in the field" data entry. (Yes we are still stuck in the 90's. We use
pencils in the field.) not PDA's.
Thier is "header" information on the Main Form. They use the Subform
for Data Entry. The Record on the Subform is created at the time of
the job via a Command Button on the main form.

Ive run into many problems with this.

1st the subform is based on a table.
(I would set the Data entry property to true but Access will not print
data entry forms).
The command from the main form opens the form with allow additions set
to true.
But the subform shows all the records, & Ive been unable to filter out
all the other records.
Ive tried a series of code using [CurrentRecord] but I cant get
anything to work.

Therefore, when I try to print the main & subform, all the subform
records print.
I want only the newly created record in the subform to print along
with the main form.

Private Sub Print_Field_Form_Click()
DoCmd.Printout acSelection
End Sub

What code can I use to filter out all subform records except for the
newly created one?
If I can get that to work, printing via (acSelection) will be
fine.
Or what code can I use to Print the Current Main Form record, & the
Current Subform record respectively.

Apr 5 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Private Sub Create_Job_Click()
Me.Field_Form_Sub_New.Visible = True
Me.Field_Form_Sub_New.Form.AllowAdditions = True
Me.Field_Form_Sub_New.SetFocus
DoCmd.GoToRecord , , acNewRec

DoCmd.ApplyFilter , Me.Form.CurrentRecord

The previous code in the Command Button's code provides the new record
& provides the filter on the Subform records, although it doesnt
actually filter out the other records.
Apr 5 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.