Determine Which Check Box Called Procedure

**jasoncw** · 05-21-2009, 01:31 PM

Hi guys.

If I have several Forms check boxes assigned to the same procedure, is it possible to tell which check box called the procedure?

Jason

**texasalynn** · 05-21-2009, 02:54 PM

why not add to the checkbox procedure

Msgbox "checkbox # was selected"

**jasoncw** · 05-21-2009, 02:55 PM

Because I will have hundreds of them, and I don't want hundreds of procedures.

**texasalynn** · 05-21-2009, 03:33 PM

I thought you said in the original post

I have several Forms check boxes assigned to the same procedure

So you don't have these assigned? I'm confused now

**Leith Ross** · 05-21-2009, 03:38 PM

Hello jasoncw,

You can with Forms Controls. Place this line of code in your macro.

Please Login or Register  to view this content.

**jasoncw** · 05-21-2009, 05:03 PM

Perfect, thanks Leith.

**jasoncw** · 05-21-2009, 05:06 PM

Originally Posted by texasalynn

I thought you said in the original post

So you don't have these assigned? I'm confused now

Just to clarify, all check boxes are assigned to the same procedure. One procedure, lots of check boxes calling the same procedure. Make sense?

Re: Determine Which Check Box Called Procedure