How do I create an automatic hyperlink from a Report to a specific Form Entry

[Zappa]

I have a database where we enter digital evidence requests from various sources. Once logged, we have a report called Incomplete Digital Evidence Requests that helps us manage workflow. One of the column headers on this form is called Case #. Each one has a unique value referencing a particular request. I'm wondering if there is a VBA code or non-coding option to assign a hyperlink to each case # in the Incomplete Requests report that corresponds to the particular request generated as a form and housed in a table.



For example (see attached photo), I'd like to run the report and be able to click on 14-029588 and have it pull up the original request in the Form view.

Thank you very much for your time and any assistance you can provide would be greatly appreciated!

- Zappa

[rpeare]

if your goal is is to bring up the evidence requests form to a specific record you can do that by opening the form and altering the RECORD SOURCE property via vba

it looks like you are using a continuous bound form which I do not particularly like but as long as you can capture the case number you can build the SQL statement or you perform the same function you use with your 'find case number' button but supply it with the captured case number from your incomplete digiital evidence requests form.

[ranman256]

I dont think you can do it in a 'report', but if you are looking at multirecord form,
put a button at the top of the form , on click

docmd.openform "frmDetail",,,"[Case#]='" & txtCase & "'"

(It may work with a hyperlinked report.)

[Zappa]

Hi Rpeare,

I have minimum experience when it comes to Access. I do have a fairly good grasp on VBA though. Could you please provide me with what the VBA Code structure would look like to alter the record source. Again, all I want to do is affix a hyperlink to each new Case # that I can open in Report View if possible. I know it has something to do with assigning the hyperlink to the CN when completing the initial form record.

Thank you again for your help!

Zappa

if your goal is is to bring up the evidence requests form to a specific record you can do that by opening the form and altering the RECORD SOURCE property via vba

it looks like you are using a continuous bound form which I do not particularly like but as long as you can capture the case number you can build the SQL statement or you perform the same function you use with your 'find case number' button but supply it with the captured case number from your incomplete digiital evidence requests form.

[rpeare]

I would rather not build something from scratch, can you provide a sample of your database with some garbage data that I could use as a base. Just make a copy of your database and put in some junk data, then zip it up and use the GO ADVANCED button to upload your zipped copy of your sample db

[Zappa]

I completely understand that. Thank you very much again for your help with this project! Attached is the requested sample database with junk data

[rpeare]

Alright my error, I had assumed both of your screen shots were from forms, but one is a report (people interchange report and form all the time here, my fault for not believing you). There is no click event available for controls on a report. The event appears in the properties but it is not usable (it can't reliably pull the field information, it usually just pulls the last record's value for a particular field).

So my suggestion is to build a form that shows the contents of your report and build your click event into that, then if they want to print the report print your existing report.

Sorry there is just no way that I know of to have click event (drill down capability) for individual records on a REPORT.

[Zappa]

Makes sense. Thank you for the advice and taking a look at this issue.

Zappa

[June7]

It is possible with report Layout view, not PrintPreview. But form is still better way.