Member already exists....

[Kyle B.]

I'm receiving this message, and its got me stumped:

The expression On Load you entered as the event property setting produced the following error: Member already exists in an object module from which this object module derives.

*The expression my not result in the name of a macro, the name of a user-defined function, or [event procedure].
*There may have been an error evaluating the function, event or macro.

....but my On Load was working a few minutes ago, and the only changes I've made should not have been related. I've even tried removing all the code from the Form_Load subroutine and I receive the same error. This seems like it's probably a minor problem, but i just can't nail it down.

Thanks in advance!
Kyle

 

[Van T. Dinh]

Have you checked and make sure you don't have 2 Form_Load Event procedures
in the Form's code module.

In the VBE, use the Menu Debug / Compile ... to make sure you don't have any
Compile Error.

--
HTH
Van T. Dinh
MVP (Access)

I'm receiving this message, and its got me stumped:

The expression On Load you entered as the event property setting produced

the following error: Member already exists in an object module from which
this object module derives.

*The expression my not result in the name of a macro, the name of a

user-defined function, or [event procedure].

*There may have been an error evaluating the function, event or macro.

...but my On Load was working a few minutes ago, and the only changes I've

made should not have been related. I've even tried removing all the code
from the Form_Load subroutine and I receive the same error. This seems like
it's probably a minor problem, but i just can't nail it down.

 

[John Vinson]

I'm receiving this message, and its got me stumped:

The expression On Load you entered as the event property setting produced the following error: Member already exists in an object module from which this object module derives.

*The expression my not result in the name of a macro, the name of a user-defined function, or [event procedure].
*There may have been an error evaluating the function, event or macro.

...but my On Load was working a few minutes ago, and the only changes I've made should not have been related. I've even tried removing all the code from the Form_Load subroutine and I receive the same error. This seems like it's probably a minor problem, but i just can't nail it down.

What do you actually see in the Form's Properties, on the Event tab,
next to the Load event? If you have VBA code you *should* see

[Event Procedure]

If you see anything else, Access will interpret the text as a macro
name and give this error if there is no such macro.