Create hyperlink in form 2

[krets]

If I have a form and one of the field displays an agent's initials, how can I make the initials appear as a hyperlink that would open up a different form with a filter or query set for those initials? Can that be done?

 

[Remou]

It may be best to just make the field look like a hyperlink (blue, underline) and use to the On Click event to open the required form. If you wish, you can change the cursor to a hand in the Mouse Move event. You can also use Control Tip Text to prompt the user.

 

[krets]

Ah, good point, I hadn't thought of that. The On Click event will work OK in a form in datasheet view?

 

[Remou]

Yes, it will.

 

[Remou]

I should add that click events can be irritating if a field needs to be edited. Double-click is often a better option.

 

[krets]

Good point. I decided to go with a button on top of the form instead so the user can highlight the record then click the button.

Thanks for the help.

 

[filthepitome]

Exactly what I was looking for as well, thanks to all involved.