info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Printing a single record in a report layout
0 views
Skip to first unread message
Adel Gaafar
Dec 11, 2002, 11:56:05 PM12/11/02
to
How can a single record be printed in a report layout
rather than the entire data base from a form vew?
rather than the entire data base from a form vew?
Duane H
Dec 12, 2002, 12:34:34 AM12/12/02
to
The single record should have a primary key field such as a numeric ID
field. Assuming this field is bound to the text box txtID then your could to
open the report would look something like
field. Assuming this field is bound to the text box txtID then your could to
open the report would look something like
Dim strWhere as String
strWhere = "[ID] = " & Me!txtID
DoCmd.OpenReport "rptMyReport", acViewPreview, , strWhere
--
Duane Hookom
MS Access MVP
"Adel Gaafar" <AG2...@Hotmail.com> wrote in message
news:061e01c2a19a$c6cf38e0$d4f82ecf@TK2MSFTNGXA11...
> How can a single record be printed in a report layout
> rather than the entire data base from a form vew?
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.427 / Virus Database: 240 - Release Date: 12/6/2002
0 new messages