Hyperlink

[sahand]

How to hyperlink the name inside datasheet to open same name as form ?

[June7]

You mean a form set in Datasheet view?

Can use the Hyperlink control to create a label with a link to form or report. But this won't apply filter.

Better to filter by unique ID, not name.

Textbox has property ShowAsHyperlink but the code to open form or report filtered to the ID of current record is the same. Use textbox Click event. I use only VBA:

DoCmd.Open "form name", , , "ID = " & Me.ID

[sahand]

thanks so much