Store Label Name in a Table

[jboyle]

I have a form that has several labels. Each of these lables has been given a unique name. When the user clicks on one of the labels, I want the name of the label to be stored in a table. What macro or event procedure could I use to store the name of the label in a table called LABEL TABLE.

 

[Robert Dunstan]

You need to create a text box that is bound to your label name field in the label table. Then in the On_Click event of your label use this code:

txtYourTextBox = lblYourLabelName.Caption
DoCmd.RunCommand acCmdSaveRecord