Control name on form is "Kit #"

The afterupdate event that fires for this control calls the control
Kit__ as per following.
What is happening here?

Private Sub Kit___AfterUpdate()
ChangeKitBase Me.Kit__
End Sub

<davjoh123@yahoo.comwrote in message
news:1ea2dc43-2fbe-4921-8492-0f2099f7d1f2@s33g2000pri.googlegroups.com...

Control name on form is "Kit #"
>
The afterupdate event that fires for this control calls the control
Kit__ as per following.
What is happening here?
>
Private Sub Kit___AfterUpdate()
ChangeKitBase Me.Kit__
End Sub

The behaviour you are seeing is a consequence of using punctuation
characters in control names. Change the name of the control (plus any
references to it) and all will be well.

"Stuart McCall" <smccall@myunrealbox.comwrote in message
news:fukiin$ni0$1$8302bc10@news.demon.co.uk...

<davjoh123@yahoo.comwrote in message
news:1ea2dc43-2fbe-4921-8492-0f2099f7d1f2@s33g2000pri.googlegroups.com...

>
The behaviour you are seeing is a consequence of using punctuation
characters in control names. Change the name of the control (plus any
references to it) and all will be well.

I just realised I didn't actually answer your question. The reason Access
changes the name is because special characters aren't allowed in procedure
names.

And the # is the character Access uses to delimit literal dates.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

Linq Adams via AccessMonster.com wrote:

And the # is the character Access uses to delimit literal dates.
>

You can concatenate "Display This#http://www.nowhere.com" to create a
hyperlink. I think it's a shame that the # character was used as people
may use the # sign to denote a number in the display part of the hyperlink.