Link the link on the from to the record your are looking at

[Finser]

Hallo,



i have created a form which gives you a direct overview of every data in the database from one animal. all the forms are nested in ech other, 3 layers of nesting. an overall form, an indivdual form nested in that and details form nested in the individuals form. but now i want to create links on the details forms, which links to even more details forms, but i want ofcourse the same individual displayed as where i was on the nested detail form, how do i do this. i already have a hyperlink?

can anyone help me
thanks

Finser

[June7]

Each of these forms is based on a different table?

I use the WHERE CONDITION argument of OpenForm:

DoCmd.OpenForm "formname", , , "ID=" & Me.ID

[Finser]

yes each form is based on a different table.

sorry i am a bite new in access, but this where condition should i type this in the visual basic window? and so yes, in the window of the form where the hyperlinks are?

thanks, Finser

[June7]

Place that code in whatever event VBA procedure you want to execute it such as a button or textbox Click.

Not sure what you mean by 'hyperlinks' - hyperlinks to what? Is this just a textbox formatted to look like a hyperlink? Is this an unbound textbox?

[Finser]

Hi june7,

I used the Hyperlink button in the design tab to create this.
this creates a hyperlink to a another form.
like the hyperlink button that is in this quick reply box.
a globe with a cable.

finser

[June7]

That is just a little wizard that creates a label control with hyperlink properties. To use the code I suggest, can't set the HyperlinkSubAddress property. Seems there used to be DisplayAsHyperlink property but am not seeing that with 2010. You can make the caption appear as a hyperlink with FontUnderline and ForeColor properties.

If you really want to use HyperlinkSubAddress property to open form, have to use another method to filter the report. The only options I can see would be a parameterized query as RecordSource or the Filter property of form. Both would reference the subform field to pull the filter criteria.