I am working on a database to manage contract documents and have posted a link to a sample version below. There are three reports in the navigation pane; each report includes a "ContractID" field which is hyperlinked to open the Contract Detail form ("frmContractDetail") for the particular contract selected. This works fine if you open the reports directly from teh navigation pane and click the links.
Now if you go to the main form ("frmMain") and click the Report Center tab, there are links on the right side of the page that open these reports using the BrowseTo method (DoCmd.BrowseTo). The problem is that when the reports load on the page, the ContractID hyperlinks no longer work: I get an error that the report referenced in the DoCmd.OpenForm statement is not open.
Here is the statement that runs when the Contract ID hyperlink on the report is clicked (this one is from the "Active Contracts" report):
Code:
DoCmd.OpenForm "frmContractDetail", acNormal, , "[ContractID]=" & Reports!rptActiveContracts.ContractID, acFormEdit, acWindowNormal
The error message I receive is: "The report name 'rptActiveContracts' you entered is misspelled or refers to a report that isn't open or doesn't exist."
Any thoughts on what I am doing wrong? Any help would be much appreciated.
http://dl.dropbox.com/u/65832352/Exa...base%203.accdb