Can't Use OnCurrent Event / Can't Find Macro

[Rational Repairs]

I have run into a sudden problem and thought I'd see if anyone else has
ran into this.

Out of nowhere (sort-of) I am not able to access the OnCurrent event on
a subform. I, of course, can write code for the event, but [Event
Procedure] under OnCurrent does not show up on the properties of the
subform, and the event does not fire.

When this problem happened, it seems to have also generated an error
while changing records in the Main Form. The error is "...can't find
the macro ".". At least I think their related...both started at the
same time.

I have never used a macro in my life.

When I say "sort-of" above, the only thing I can think that I may have
done is this: When quickly "ALT-TAB'ing" between my form and the VB
editor, I *think* I accidently deleted the words [Event Procedure] out
of the said OnCurrent event. Although, I'm quite sure I have done this
in the past, and was able to just re-initiate the event, and move on.

Now, when I try to re-initiate the event (by clicking the "..." symbol
next to the event) it brings up the EXPRESSION BUILDER! Not the Choose
Builder request like it should.

I have tried everything short of re-creating the form completely
(compact/repair, export form - c/r
- import form, ext...)

Anybody ever see this?

[ruralguy via AccessMonster.com]

You should be able to just type in [Event Procedure] in the event slot and it
will begin working.

Rational Repairs wrote:

>I have run into a sudden problem and thought I'd see if anyone else has
ran into this.

Out of nowhere (sort-of) I am not able to access the OnCurrent event on
a subform. I, of course, can write code for the event, but [Event
Procedure] under OnCurrent does not show up on the properties of the
subform, and the event does not fire.

When this problem happened, it seems to have also generated an error
while changing records in the Main Form. The error is "...can't find
the macro ".". At least I think their related...both started at the
same time.

I have never used a macro in my life.

When I say "sort-of" above, the only thing I can think that I may have
done is this: When quickly "ALT-TAB'ing" between my form and the VB
editor, I *think* I accidently deleted the words [Event Procedure] out
of the said OnCurrent event. Although, I'm quite sure I have done this
in the past, and was able to just re-initiate the event, and move on.

Now, when I try to re-initiate the event (by clicking the "..." symbol
next to the event) it brings up the EXPRESSION BUILDER! Not the Choose
Builder request like it should.

I have tried everything short of re-creating the form completely
(compact/repair, export form - c/r
- import form, ext...)

Anybody ever see this?

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200611/1

[Rational Repairs]

Damn, I wish I would have tried that. I ended up recreating the
sub-form (via copy/paste), and that fixed the problem. Thanks for the
tip though!

Jeff Smeker

On Nov 10, 9:38 am, "ruralguy via AccessMonster.com" <u12102@uwe>
wrote:

You should be able to just type in [Event Procedure] in the event slot and it
will begin working.

Rational Repairs wrote:

I have run into a sudden problem and thought I'd see if anyone else has
ran into this.

Out of nowhere (sort-of) I am not able to access the OnCurrent event on
a subform. I, of course, can write code for the event, but [Event
Procedure] under OnCurrent does not show up on the properties of the
subform, and the event does not fire.

When this problem happened, it seems to have also generated an error
while changing records in the Main Form. The error is "...can't find
the macro ".". At least I think their related...both started at the
same time.

I have never used a macro in my life.

When I say "sort-of" above, the only thing I can think that I may have
done is this: When quickly "ALT-TAB'ing" between my form and the VB
editor, I *think* I accidently deleted the words [Event Procedure] out
of the said OnCurrent event. Although, I'm quite sure I have done this
in the past, and was able to just re-initiate the event, and move on.

Now, when I try to re-initiate the event (by clicking the "..." symbol
next to the event) it brings up the EXPRESSION BUILDER! Not the Choose
Builder request like it should.

I have tried everything short of re-creating the form completely
(compact/repair, export form - c/r
- import form, ext...)

Anybody ever see this?--

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2006...- Hide quoted text -- Show quoted text -