UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> open a report from a continuous form    
 
   
gruebz
post Jan 20 2008, 10:20 AM
Post #1

UtterAccess Addict
Posts: 160



hi,
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
Go to the top of the page
 
+
Peter46
post Jan 20 2008, 11:00 AM
Post #2

UtterAccess VIP
Posts: 7,489
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.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 1st September 2014 - 02:30 AM