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