PRINTING ONLY A SPECIFIC RECORD IN A TABLE

  • Thread starter PRINTING A SPECIFIC RECORD IN A TABLE
  • Start date
P

PRINTING A SPECIFIC RECORD IN A TABLE

How do I create a report which prints only one record in my table on a field
say "PersonName" which contains a value passed from a database lookup?
 
C

Chris B via AccessMonster.com

Hi, You need to make a query and base you reports "record source" on this
query.
So your query should look somewhat like this:

Field:personName*
Table:person details

Field:personNameID (the primary field)
Table:person details
Criteria:[Forms]![PersonNameID]![PersonNameID]

HTH
 
L

Larry Linson

"PRINTING A SPECIFIC RECORD IN A TABLE" <PRINTING A SPECIFIC RECORD IN A
[email protected]> wrote in message
How do I create a report which prints only one record in my table on a
field
say "PersonName" which contains a value passed from a database lookup?
Click to expand...

Many reports are printed by clicking on a Command Button, which executes the
DoCmd.OpenReport method. That method has an argument called Filter, and
another called WhereCondition, either of which can be used to supply
criteria to the Report's Record Source. Open any module, in design view,
type in and put the cursor on OpenReport, press the F1 key, and you should
get good help.

It takes only a little knowledge of VBA to use the Help and sample code to
modify the DoCmd.OpenReport statement that is automatically generated by the
Command Button Wizard.

Larry Linson
Microsoft Access MVP
 
Top