subform problem after table name change

[Pawser]

A user recently made a change to a table in an Access 2000 db (I know, but I’m a volunteer and the org’s a nonprofit that insisted on access to the tables, etc). First he copied the table and renamed it ("basicdata--orig"), then made the change to the copy and gave it the name of the original table ("basicdata"). This table is filled by entries in a form that also has several subforms that create records in linked tables.

Data entered into the main entry form are correctly inserted in the new table ("basicdata"). Data entered in the SUBforms, however, now cause an error stating that the data cannot be saved because no corresponding record exists in "basicdata--orig" (the table that was replaced). Apparently, the main form retained the linkage to the table NAME "basicdata", but the subforms somehow followed the original table's NAME CHANGE and are now looking to it for the corresponding records. Of course, the records are not there.

1) I'd like to understand just what went on here and 2) I cannot find any refence to "basicdata--orig" in the properties of the subforms so I don't know what to change to correct the problem. I realize I could correct it by switching the table names back again, but that action would necessitate some reentry of data that I'd like to avoid.

I know this is probably as clear as mud, but if anyone has followed it and has some answers, I'd sure appreciate hearing them. Thanks!

 

[MattCollins]

What is the record source of the subforms?

 

[Pawser]

The record source for the subform is given as the table in which the data for that subform are to be saved. There are several subforms on this main form, each dealing with different pieces of data that get saved to different tables that are individually linked to the main form. The error message appears when trying to enter data in any of these subforms.

The record source for the main form is "basicdata", which makes sense because that is where the data are being saved. Nowhere can I find any reference to "basicdata--orig", which is where the subform is apparently looking for a matching record.

The master and child links are both given as IDNumber, which is correct. But I can't find any place where it tells me what where it's looking for this information.