hyperlinks vs command buttons

[LMB]

I went to a class in access 2003 and they suggested using hyperliks to
navigate to reports, forms etc...it seems really simple and worked well.
What would be the drawback from doing this?

Thanks,
Linda

 

[Brendan Reynolds]

It's less flexible. The OpenForm method has six optional arguments that you
can use to specify how the form or report should be displayed and what data
it should contain. Hyperlinks don't offer the same versatility.

 

[LMB]

Do you mean like opening the form maximized or to show certain records?

Linda

 

[Brendan Reynolds]

Among other things, yes.

 

[Rick Brandt]

Do you mean like opening the form maximized or to show certain
records?

One example is that you can use code to test something before you decide to
open the form/report or not. A Hyperlink has no way easy to be "cancelled".

I like the look of using hyperlinks and used them a lot in the past. The
limitations though now have caused me to abandon them entirely. What I do
now is use a label with a HyperlinkSubAdress of " " and then use code in the
Click event to do what I want. This still gives me the blue underlining and
pointing hand cursor of a hyperlink, but with none of the drawbacks.

There are some that would say "A solution that doesn't need code is better
than one that does." I would generally agree with that if the non-code
solution is not otherwise inferior. Hyperlinking around in Access apps
definitely is.