Good Morning,

  Using Access 2003, I have a form w/ subform that when I close, without modifying anything on either form, I receive two messages.

  The first is you cannot save changes - which I supressed with the acDataErrContinue on the Form_Error event.

  Unfortunately, I cannot seem to suppress the next dialog, indicating you cannot save this record at this time.

  Any suggestions would be appreciated.

  Thank you for your time.

Welcome to P2P!

What else does the error messge say? (IE-- is it reporting a key violation?)

And you are sure you nothing is automatically populating to the subform......

HTH,

Loralee

Do you have any code that pauses or makes certain things appear/disappear/change after a certain amount of time? If the code is still running it can give errors when you try to interrupt it with a close or edit.

Good Evening,

  Thank you for your replies.

  This form and sub-form have no routines running. They populate based on queries. When it opens it reads the query to populate the fields, however; if nothing is present, then nothing fills the bound controls.

  If nothing fills the bound controls and you attempt to close it, then those two error messages are all you get.

  As stated, I can suppress one with the "acDataErrContinue" in the Form error handler, but I still get the last one.

  Basically it is saying I am attempting to save a record with a missing related record in the base table. But, since there is no data, nothing should be attempting to save.

Ah, so essentially you're trying to open a form bound to a query that is returning no results? The problem is most likely that Access is defaulting to a blank record for you to create, and doesn't much like when nothing is input into it after it's open. Add a check in your code before opening the form to ensure the recordcount of the query you're pulling data from is greater than zero.