open a report from a continuous form
Jan 20 2008, 10:20 AM
Joined: 8-January 08
ve just a set up a table where i enter the name of all the reports in my database. now i want to create a continous form based on that table where if the user clicks on the name of a report (which i am assuming would be best to be listed as a hyperlink) that report is opened. just a little bit confused how to do this as when designing a continous form all the data is entered once so im not too sure how to make the form know which form to open.
any help is much appreciated
Jan 20 2008, 11:00 AM
Joined: 3-October 05
From: Oadby Leics, UK
There is no need to use hyperlinks. Set the field up as a text field.
On the Click event of the control which hold the report name (I'll call it txtRptName) you have:
docmd.OpenReport me.txtRptName, acViewPreview
to open in Preview mode.
|Search Top Lo-Fi||31st January 2015 - 03:32 AM|