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!

[rpeare]

Are you LINKING or IMPORTING the source table. Let's say your sharepoint table is TABLE_1. In your access database is this a linked object or a standard database object?

What is the code of your ON LOAD event?

If the table is linked, try creating a local table with the same name (rename your linked table to something else) and the same fields/data types and see what happens. If it works it may be a minor corruption issue and you'll need to compact/repair.

Can you provide a sample database that does not work?