Stop a form from saving itself when opened

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have a form with a large subform (subform is in form view) that saves
itself everytime it is opened. It takes approximately 20 seconds for the form
to save itself prior to it being visible. There is quite a bit of code both
in the form (about 30 pgs when copied onto word), subform and in called
functions in a function module. Is there any way to stop the form from saving
itself everytime it opens.
Thanks in Advance.
Capthfd
.

Relevant Pages

  • Re: Stop a form from saving itself when opened
    ... What makes you think it's saving itself? ... >I have a form with a large subform that saves ... > itself everytime it is opened. ... > functions in a function module. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: saving data on closing form
    ... >everytime I change something on subfrm. ... AfterUpdate events) the instant you set focus to a subform. ...
    (microsoft.public.access.formscoding)
  • Re: Closing form and saving data
    ... Focus from the main Form to the Subform. ... You cannot disable the AutoSave feature. ... > everytime I change something on subfrm. ...
    (microsoft.public.access.formscoding)
  • Numbering Rows (and saving the number on a table)
    ... I need to number the rows in a subform. ... I used Stephen Lebans mdb but since i need to save the row number in a table ... value to another textbox access freezes... ... everytime something is deleted it gets messed up. ...
    (microsoft.public.access.gettingstarted)
  • Re: multiple entries for same field on a form
    ... and show it like a subform or listbox ... I need a way to enter a date everytime ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)