Web Development

Ask something
Question Locked

Hyperlink

0 helpful
4 replies

by john.ferringer

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Can I create a hyperlink in a report that when clicked will replace the same value as what I click into my query criteria.

For example...

I may get the following results in a report

Change this filter
Investigate root cause of this failure
Purchase this item
etc

I want each result to be a hyperlink that on click, it transfers the same ie. "Change this filter" to the criteria box in a query.

In turn this query will open a form that I can edit more information about the item.

Thanks in advance,
John

4 replies

by robo_dev

what platform,database, and web language is this?

If I understand correctly, your app has rendered a html report with hyperlinks in it....but you lost me from there.

So the result would be something like

[Purchase this item] toaster

so when you click on the purchase button, it opens an input box for the 'toaster' item in the database?

the answer is a big 'it depends' on what you're using.

For example, if this were JavaScript, the 'onclick' method could do exactly that...you would do a call to the appropriate database record from there.

If the output were rendered in excel, you could refer the one cell to the other....

by john.ferringer

Hello Robo and thanks for trying to help! I'm not sure I understand your questions, but let me see if I can add clarity. It's just a 2007 access document. I call it the GamePlan. There are a bunch of sub-reports included in a main report. On the game plan, each sub-report is filtered to an issue or idea topic like Repair, Issue, Idea, Capital, etc.

Right now I have to use a command button on the top of the page and I put a [Enter idea number] in the query, so when They press the command button, the query asks for the # and when I enter that, it opens a form to edit the topic.

What I want to have happen is that instead of having to scroll through each topic, look at the topic #, and then enter the # to open the report, I would like to just have the topic text on the report be a hyperlink that when I click the hyper link, it opens the form to edit the topic. Thay way, I can eliminat the need to scroll back to the top of the report and enter the # associated with the topic to get to the edit form.

This discussion is closed to new replies.