Forms will not save changes

Question

Hi,

I have never had this issue, suddenly I cannot save the forms in my database, I can modify them, when I close them I get the popup asking I want to save, I click yes, but then nothing happens. The form does not close and does not save.

Any idea why this is happening and how I can solve this?

Thanks

Jeannie

Answer 1

Try a compact.

Try creating a new blank database and importing everything.

Answer 2

I recreated the query and it now works

I guess everything was because of that

Thank you for your help, it is appreciated

Answer 3

Hi Daniel

This fixed one issue, two of the forms could not be imported, so I copied manually (copy/paste) from one to the other.  This fixed FRMone which is my "menu". However, I am still having an issue with a dropdown list on FRMcost.  The control source is SELECT [TBLtransport].[Sendby], [TBLtransport].[TRANSPORT] FROM TBLtransport ORDER BY [Sendby];

When I am n the main table, TBLimportation, I can pick from the dropdown list and what I picked will appear in the form, however, when in the form, I see the dropdown list and I cannot pick anything

Any idea?

Thanks

Jeannie