Nicholson, Karen
cyx5 at cdc.gov
Fri May 6 09:59:52 CDT 2005
I have several controls on a form. Each is named as Ctl1_IF. I want to be able to capture the name of each control, pulling the text to the right of the Ctl and use it in calculations. I am tired of typing it over and over... and it is Friday so where is all the humor at? Here is an example of one of the pieces of code Private Sub Ctl1_IF_AfterUpdate() If (me.[1-IF] > 99) Then me.result = "FAIL" End If Question is, sucking out the name of the current control... Thanks.