Thanks for your help with this, Jeanette.
"Jeanette Cunningham" wrote:
> Try it with a close button and disable the form's X.
>
>
> Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
>
>
> "Mary Fetsch" <(E-Mail Removed)> wrote in message
> news:BF872F57-5ADA-4128-8E0F-(E-Mail Removed)...
> > Thanks for your quick response, Jeanette. I don't close the form using
> > VB.
> > The user can enter as many records as she wants before closing the form.
> > So
> > the user controls when the form should be closed and then clicks the
> > form's X
> > or clicks File Close. I seems to me that the only way I can control the
> > closing is to have a Close button on the form. Or do you have a better
> > idea?
> >
> > "Jeanette Cunningham" wrote:
> >
> >> Hi Mary,
> >> in the code that closes the form, you can use
> >>
> >> DoCmd.Close acForm, Me.Name, acSaveNo
> >>
> >> Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
> >>
> >>
> >> "Mary Fetsch" <(E-Mail Removed)> wrote in message
> >> news:F6CC1B16-E8F9-4EBC-AFB9-(E-Mail Removed)...
> >> >I have an Access 2003 adp that I'm converting to Access 2007. I'm
> >> >adjusting
> >> > the record source of a form using Visual Basic. In version 2003, this
> >> > didn't
> >> > change the record source in the actual form. In version 2007, there
> >> > are
> >> > conditons where the record source in the actual form is being changed -
> >> > when
> >> > I close the form, I'm asked if I want to save the form changes. This
> >> > is a
> >> > problem because I never want the user to save form changes. I don't
> >> > want
> >> > the
> >> > form's actual record source changed. Is there an option I can set so
> >> > that
> >> > form changes aren't allowed? Or is there something else I can do?
> >> > Thanks!
> >>
> >>
> >>
>
>
>
|
Similar Threads
