PLEASE HELP!!!! Changing Record Source - No functions / events work

[adamk]

Hi All,

I have created a system consisting of a data entry form etc. It was originally connected to one record source exported from a sharepoint site.

I had to add a field to the sharepoint site and so i created this additional field and re-exported the data and changed the forms record source and all occurences in the code of previous to new record source.

However, this change of record source produces the following error on every single event.

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

*for every event*

I tried to break the code as soon as it hits the load function to track the error - but it doesn't even run this function so the code is not executing at all.

When i connect back to the old record source it works fine.

I'm relatively good with solving errors but this I just have no idea and have seemingly tried everything, PLEASE HELP

Thanks!
​

 

[MarkK]

You can cause that error with this code in the module of an Access.Form ...

Property Get Dirty()
End Property

... because an Access.Form already exposes a property called Dirty()

When you write code in a Form's class module you are in fact extending the Access.Form class using inheritance.

Look for a a member you wrote with the same name as a member exposed by the parent. These code examples in an Access.Form's module cause the same error...

Dim FilterOn As Long

Function InsideHeight()
End Function

Sub Requery()
End Sub

Those are all already members of the Access.Form class.