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

Print preview resets the form

P: n/a
Hi, suppose I want to print third record from a subform.
The problem is, that when I want to print what I see on my monitor
(third record), the print preview resets
the form to the first record (wants to print the whole form beginning).
Is the any possibility to print a particular record, without making
screenshots?
Please, help me!!!

Jan 22 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
hosi wrote:
>Hi, suppose I want to print third record from a subform.
The problem is, that when I want to print what I see on my monitor
(third record), the print preview resets
the form to the first record (wants to print the whole form beginning).
Is the any possibility to print a particular record, without making
screenshots?

That's what printing a form does. You should use a report
to display a record's data.

Create the report based on a query that retrieves the
desired fields for all possible records. Then add a button
to your form to print the current record by using the
OpenReport method's WhereCondition argument. The general
idea is something like:

Dim stWhere As String
stWhere = "[the pk field] = " & Me.[the pk field]
DoCmd.OpemReport "name of report", , , stWhere

--
Marsh
Jan 22 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.