Error while trying to save record

[kleabo]

Hello, I have a simple database that is set up 9 tab sheets. Each sheet contains approx 15 question with yes/no fields. The only macros I am using are to sum the yes/no fields.
The problem I have is .. When ever I make a change to a record it will not allow me to go back into design mode, save or exit.
I am getting the following error..
"You can't save record at this time.
Microsoft Access may have encountered an error while trying to save record. If you close this object now, the data changes you made will be lost."
Any Ideas.. thanks (I love this site)

 

[yellow]

If you have a primary key in a table and you have not completed that information it would give you that message when trying to enter design mode....

 

[kleabo]

My primary key is an ID number which is set to autonumber.

 

[yellow]

Before the 'Unable to save'... message, do you not get another error message?

 

[kleabo]

no...
If I go into the database and do not make any changes at all I can enter the design mode. But once I make a change I can no longer enter the design mode

 

[yellow]

Could be many things. Try entering data directly into your table. Then go to the next record. If that doesn't error then it is something to do with your form...

 

[kleabo]

I checked the table and it did work properly... had no problems..
I can't seem to pinpoint the problem in the form though?

 

[kleabo]

I found my problem... I had a macro that no longer existed in my form properties. I removed it and now it seems to be functioning properly.. Thank you so much for you help. I have learned a lot from this forum. Have a good one.
Kim