only one record prints

  • Thread starter Thread starter kram
  • Start date Start date
K

kram

I'm a new access user - I made a report to be able to
print out a series of records associated with a table, but
only one record prints out and then only a specific one.
It sound basic, but I can't figure out what I'm doing
wrong.
 
I'm a new access user - I made a
report to be able to print out a series
of records associated with a table, but
only one record prints out and then
only a specific one.
Click to expand...

"Made a report" isn't very specific. Perhaps you could clarify... what is
the RecordSource of your Report? If it is a Query, do you have Criteria? If
it is not, are you running the Report from a DoCmd.OpenReport that has
either a Flter argument or a WhereCondition argument? Are you running the
Report by choosing it from the list of Reports in the Database window, or
some other way?

Larry Linson
Microsoft Access MVP
 
-----Original Message-----


"Made a report" isn't very specific. Perhaps you could clarify... what is
the RecordSource of your Report? If it is a Query, do you have Criteria? If
it is not, are you running the Report from a DoCmd.OpenReport that has
either a Flter argument or a WhereCondition argument? Are you running the
Report by choosing it from the list of Reports in the Database window, or
some other way?

Larry Linson
Microsoft Access MVP
Click to expand...
I have the exact oposite problem.
When i click the button i get all the record while i only
want the one selected. When i check the properties of the
eventprocedure i see the following.

Dim stDocName As String
stDocName = "Student Incident Sheet C&MD"
DoCmd.OpenReport stDocName, acNormal
Exit_Printer_Click:
Exit Sub
What i would like todo is that the report prints the
record i am on.
Any advice?
Thank you,
Tariq
 
Back
Top