turning labels into command buttons

[Guest]

I have someone putting together a layout of a floor with labels that show
rooms on each floor. I need to change the labels into command buttons that
will navigate to other forms. Any quick easy way to convert labels into
command buttons(that will allow me to use the wizard to tell it to open
another form).

Thanks,
Barb

 

[fredg]

I have someone putting together a layout of a floor with labels that show
rooms on each floor. I need to change the labels into command buttons that
will navigate to other forms. Any quick easy way to convert labels into
command buttons(that will allow me to use the wizard to tell it to open
another form).

Thanks,
Barb

If you are using labels from the ToolBox (i.e. not attached to a text
control), these labels have events. You can code the label's Click
event to open another form:
DoCmd.OpenForm "OtherFormName"

If the label is connected to a text control, you can select the label,
Cut it, then Paste it. It is now disconnected and has events you can
use, as above.

 

[babyatx13 via AccessMonster.com]

I have someone putting together a layout of a floor with labels that show
rooms on each floor. I need to change the labels into command buttons that
will navigate to other forms. Any quick easy way to convert labels into
command buttons(that will allow me to use the wizard to tell it to open
another form).

Thanks,
Barb

Look in properties of the label, look for Hyperlink Address, click the … at
right, this brings up edit hyperlink box, in the link to pane at left click,
Object in this database and link to what ever form, table or report you want,
If you are linking to a website or a file on your computer/network use the
Existing file or webpage button.


K Board