SOLVED: Access Error

[Rollin_Again]

Can someone please tell me what would be causing the following errors to
occur when trying to open my Access Form

"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"


What have I done to cause this error to occur?


Rollin

[SJ McAbney]

What code do you have in the OnLoad event?

[Rollin_Again]

What code do you have in the OnLoad event?

Private Sub Form_Load()

cmbVendors = cmbVendors.ItemData(0)
Call cmbVendors_AfterUpdate
Call EditMode(False)

End Sub

Rollin

[GP George]

If you have created a function called EditMode, Access is confused because EditMode is a property of dao and ado recordsets and can't be set this way.

Rename your function to something else, like SetEditMode, and try again.

HTH

George

[Rollin_Again]

If you have created a function called EditMode, Access is confused because EditMode is a property of dao and ado recordsets and can't be set this way.

Rename your function to something else, like SetEditMode, and try again.

HTH

George

Thanks George,

I've only got about 10 hairs left in my head from pulling them out trying to solve this problem. Indeed the problem was due to the name I gave one of my sub-procedures.

Rollin

[SJ McAbney]

I'll close this now that it's solved but, before I do:

[vba]cmbVendors = cmbVendors.ItemData(0)[/vba]

Change this to:

[vba]Me.cmbVendors = Me.cmbVendors.ItemData(0)[/vba]

The compiler likes that