X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> open a report from a continuous form    
post Jan 20 2008, 10:20 AM

Posts: 160
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
Go to the top of the page
post Jan 20 2008, 11:00 AM

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

Custom Search
RSSSearch   Top   Lo-Fi    24th January 2017 - 06:32 AM