Error in subprogram

[Lou_Reed]

This request is I believe quite simple. The attached file when you open form frmEmail it

gives a Me.chkTicketAssigned error.

The method is not found. But the method is the subprogram.

It makes no sense that it fails internally here. The is the subprogram at the top of the VBA code for that
form.

Any help appreciated. Thanks in advance.

Respectfully,




Lou Reed

[jwhite]

Confused... There is no control named "Me.chkTicketAssigned" on frmEmail. The error is occurring in the On Current event, advising "Me.chkNeeting_Invite" not found - this is not on the form either. There are no check boxes on the form.

[John_G]

But the method is the subprogram.

No, it's not. There is a subprogram called chkTicketAssigned_AfterUpdate, which from its name is the event code for the After Update event for a form control called chkTicketAssigned. However, there is no control called chkTicketAssigned on the form, and because Me.chkTicketAssigned is trying to refer to a non-existant control, you get an error.

Under normal circumstances, you can't see or write code for methods - it's built in. If you write your own subprogram or function, then you don't reference it using Me. , you just use its name.


PS - there are also syntax errors in the code module for that form.

[Lou_Reed]

You are right!

That is why it is not working. I obviously took the source code from a working program and then just changed the name TicketAssigned. That is not enough.

It is an after update event so that must be selected in event properties. That is why it is wrong. I will make those corrections now.

The question is how does one put in an AfterUpdate event? It (AfterUpdate) seems to not to be a choice in data properties.

So how too I get the first and last line of VBA code for an AfterUpdate event?

Thanks for your input.

Respectfully,

Lou Reed

[Lou_Reed]

Never mind. I got the AfterUpdate event in the properties. I think that I can do this now.