Preview report of specific record

  • Thread starter Thread starter rkroegerjr
  • Start date Start date
R

rkroegerjr

I have a form for data entry. Each record that is entered using this
form has a unique control number. Can a command button be set up to
bring up a preview of a specifc record? In other words if I'm on a
form for a specific control numbered record couldn't a report be
previewed for that same form? I can get a command button to print for
a specific record but I can't preview it. Thanks for any help
 
I have a form for data entry. Each record that is entered using this
form has a unique control number. Can a command button be set up to
bring up a preview of a specifc record? In other words if I'm on a
form for a specific control numbered record couldn't a report be
previewed for that same form? I can get a command button to print for
a specific record but I can't preview it. Thanks for any help
Click to expand...


The command button wizard should give you that choice.

If you look at the button's Click event procedure, you
should see a line llike:

DoCmd.OpenReport stdocname, acViewNormal . . .

Change the acViewNormal to acViewPreview
 
I'm sorry, I didn't explain this clearly. I am able to preview the
report. What I want to do is preview only the report for the record
that corresponds to the record on the form. I am able to set up a
print command that will print only the record but I haven't been able
to do this with the preview
 
I'm sorry, I didn't explain this clearly. I am able to preview the
report. What I want to do is preview only the report for the record
that corresponds to the record on the form. I am able to set up a
print command that will print only the record but I haven't been able
to do this with the preview
Click to expand...


Just modify the code that prints the record to use
acViewPreview instead of acViewNormal.
 
Back
Top