Report Hyperlink to specific record in a form

[Izzygrace3]

I have built a report that I would like to have a hyperlink field that will direct the user to the entry form so that they can edit the information for that record. I have been successful in hyperlinking to the form, but I have not been able to get it to open the form to the specific record that is being clicked.

Thank you!

 

[boblarson]

1. Kind of backwards if you ask me. But that being said,

2. Don't set it as an actual hyperlink. And then set its format to blue and underlined and the property IS HYPERLINK to YES (so it will show the hand). Then

3. Use the DoCmd.OpenForm command in the control's CLICK event where you can insert a Where Condition

DoCmd.OpenForm "FormNameHere", WhereCondition:="[IDFieldNameHere]=" & Me!IDField

 

[pr2-eugin]

Hyperlink to a Record? Hmmm.. First time that I am hearing about.. What you need is OnClick method use a DoCmd.OpenForm.. Something like..
If It looks like this for a numeric value

DoCmd.OpenForm "SecondFormName", , , "FieldName = " & Me.ControlName

It looks like this for a Text value

DoCmd.OpenForm "SecondFormName", , , "FieldName = [B][COLOR=Red]'[/COLOR][/B]"  & Me.ControlName & "[COLOR=Red][B]'[/B][/COLOR]" [COLOR=Green]   '(note, that's a double quote, single quote and double quote at the end)[/COLOR]

It looks like this for a Date value

DoCmd.OpenForm "SecondFormName", , , "FieldName = [COLOR=Red][B]#[/B][/COLOR]"  & Me.ControlName & "[B][COLOR=Red]#[/COLOR][/B]"