Re: CreateEventProc error

"dchman" <dchman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:37570C0D-DD19-4968-834F-4DE1BA2683EE@xxxxxxxxxxxxx
One of the controls being added is a subform (along with setting its
ObjectSource), which seems to be the cause of the prompt. If I don't
add the subform, the prompt is not raised. Any ideas how to suppress
the prompt caused by the subform?

You might try explicitly saving the form befor closing it. That is,
instead of this:

DoCmd.Close acForm, frmCurrent.Name, acSaveYes

use this:

DoCmd.Save acForm, frmCurrent.Name
DoCmd.Close acForm, frmCurrent.Name

But I wonder; did you change any of the properties of the subform
control's SourceObject? That would lead to a need to save both forms.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.

Relevant Pages

  • Re: how to get rid of the prompt for saving changes
    ... as I have to have the setup options work ... I use .ColumnHidden in some of my 2000+ stuff, and don't get the prompt to save changes. ... I got the idea to use a blank subform on close, ... The only time you'd get this prompt would be if you make Design changes ...
    (comp.databases.ms-access)
  • Re: Closing an Empty Form
    ... I don't know for sure that the system would prompt for all 3 of the ... combo-box fields because as you noted, the system crashes after I cancel the ... However, if I re-arrange those fields within the query, the ... RECEIPTID is the auto-generated number key and is what ties it to the subform ...
    (microsoft.public.access.queries)
  • Re: how to get rid of the prompt for saving changes
    ... opened that resets the date format for any date fields (this is to ... I got the idea to use a blank subform on close, because it would prompt to ... The only time you'd get this prompt would be if you make Design changes to ...
    (comp.databases.ms-access)
  • Re: how can I programatically close a subform
    ... Then I modify some of the properties for controls on the subform with code ... At runtime, when this line is processed, the prompt appears asking to save ... If I don't modify any of the control ... Should I just use the DoCmd.SetWarnings False to suppress the prompt? ...
    (microsoft.public.access.forms)
  • Re: how to get rid of the prompt for saving changes
    ... versions of access after 97), if you have a form that has a subform, and you ... The only time you'd get this prompt would be if you make Design changes to your objects. ... ..SourceObject to a blank object would stop this message, ...
    (comp.databases.ms-access)
Loading