How can I make a label a button?

[BrainKing]

Hello,



How can I make a label open up a table? I want the label to have a background colour of orange because you can't do it with a normal command button I believe.

Any idea?

[pbaldy]

As answered elsewhere, a label has a click event that can do anything a button can do.

[pbaldy]

I would add that you can make the button back style transparent and put a label of the desired color behind it.

[BrainKing]

Forget it. I made a command button but I can't find the event where it opens up a table..only add record, delete record, duplicate etc. I want a table opened.

[pbaldy]

I would never open a table directly for a user, but the command would be:

DoCmd.OpenTable...

[BrainKing]

Can't find the Macro DoCmd :O

My table name is Customer Details

what would the exact command be and where would I write it?

[pbaldy]

I don't use macros, but the macro action would be OpenTable. What I gave was VBA code, which would go here:

http://www.baldyweb.com/FirstVBA.htm

And VBA help would have the full syntax and available options.