Using combo box to select report..preview-print 1

[ggreg]

What I would like to do is place all my report names in
a field in a table and then relate those reports to poeple
so if a certain person opens a form it will have a combo box with only certain reports that are theirs, I can do
the combox part but how do I get a report once selected in
the combo box to preview print?

 

[dhookom]

Use the after update event of the combo box to open the report. I usually add a command button to open the report that is named in the combo box.
DoCmd.OpenReport Me.cboReports, acViewPreview

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[ggreg]

dhookom,

It works great!

Thanks