not able to save records on form (1 Viewer)

[jedder18]

I have this form.
It's been running correctly until....

They wanted yrs of data purged.
I ran a query to find the Client ID's with old yrs and no activity.
Appended to the structure only of a new table.
Replaced/renamed old table with the new data and changed the new table name to what it was previously, to be used in all the existing queries...etc.
I can no longer get the Save Record command to work.

Is it because I changed the name of the table?
The queries on this form have not been changed in any way.
The links have not been changed...
I just used the new (updated client)table in them which has the same table name and structure as previously used and prev used table has been renamed.

thoughts, ideas, suggestions?

 

[sneuberg]

The queries on this form have not been changed in any way.

If you change a table name the queries that use the table are changed so that they use the new table name. Normally you would want this. You can change a table name without breaking the queries but maybe it messed you up in this case. I suggest checking the queries to see if they are still what you want.

 

[jedder18]

this was an easy fix.
I took out the save record button.
It automatically saves on the subform with the cliendID link.