Hyperlink

[Very Basic User]

Is there a way to command a hyperlink to pull up a record in a form that is
same as the link I clink on.

Example.
Right now I have a summary report with multiple "General Descriptions"
listed along with the corrisponding Item #.. The way it works now is that a
user will push a command button that opens a form in edit mode. The form in
edit mode is being pulled by a query with [Enter Item Number] command. So
when the user pushes the button, they have to look at the summary level
report and type the # associated with the item then click enter and it opens
the Form to allow for edits to the record.

What I want to happen:
Each item is a hyperlink on the summary report. When I click the hyperlink
for a particular item, it filters to exactly what I clicked on and the edit
form will open with that record.

I have already made each record a hyperlink, but don't know what to do in
the "on click" macro.

Please help and thank you!

 

[MikeJohnB]

I am not sure what you are trying to do with the hyperlink, I'm not even sure
if its possible.

However, you can convert your parametric query to pull the value of the
detail in the Item Number field on your main form that way when the user
clicks the button to run what ever you want to drive, form or report, the
parameter is entered into the criteria of the query without the user having
to type anything in at all.

If I have understood what you are trying to do:

With your query in design view, right click in the criteria row of the Item
Number, select build, use the expression builder to select the control on
your main form that carries the Item Number.

This will replace the [Enter Item Number] Parameter of the query with
whatever value is current in the Item Number Control of your main form.

I hope this helps and that I have understood what you are attempting to
do??? Please let me know.

Kindest regards
Mike B

 

[Very Basic User]

Hello Mike,

I think I way over complicated my question. To simplify, All I need to do is
run a query from a hyperlink that would change the query criteria depending
on the selection.

For examply.

On my report, the following ideas may come up.

Change this process
Revise this draft
Update this item

I want to turn each of these into a hyperlink that when I click on the
hyperlink, it would automatically transfer the statement into my criteria
area of the query. So if I Clicked on "Change this process" the query would
run for only "Change this process"

 

[Very Basic User]

Mike,

One other thought may be to use the hyperlink (On click) command to open a
form for that specific record in edit mode. is there a way to do this and
what might the code look like if possible
--
Thank you for your time!
John

Hello Mike,

I think I way over complicated my question. To simplify, All I need to do is
run a query from a hyperlink that would change the query criteria depending
on the selection.

For examply.

On my report, the following ideas may come up.

Change this process
Revise this draft
Update this item

I want to turn each of these into a hyperlink that when I click on the
hyperlink, it would automatically transfer the statement into my criteria
area of the query. So if I Clicked on "Change this process" the query would
run for only "Change this process"



--
Thank you for your time!
John

Is there a way to command a hyperlink to pull up a record in a form that is
same as the link I clink on.

Example.
Right now I have a summary report with multiple "General Descriptions"
listed along with the corrisponding Item #.. The way it works now is that a
user will push a command button that opens a form in edit mode. The form in
edit mode is being pulled by a query with [Enter Item Number] command. So
when the user pushes the button, they have to look at the summary level
report and type the # associated with the item then click enter and it opens
the Form to allow for edits to the record.

What I want to happen:
Each item is a hyperlink on the summary report. When I click the hyperlink
for a particular item, it filters to exactly what I clicked on and the edit
form will open with that record.

I have already made each record a hyperlink, but don't know what to do in
the "on click" macro.

Please help and thank you!