Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / September 2004

Tip: Looking for answers? Try searching our database.

Updating records

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
D'Lilah - 03 Sep 2004 20:19 GMT
I have a data entry form that contains a couple of subforms.  I would lke the
user to be able to enter all of the information on the form (including
subforms) and then confirm the update prior to the records being saved.  Is
there a way to do this?  I am not very good at code, but am sloooowly learn.  
Any help is greatly appreciated.  If I have not provided enough information,
please let me know.
Van T. Dinh - 03 Sep 2004 23:01 GMT
That's actually not easy to do.  In a bound Form / Subform combination,
there is an feature called "AutoSave" running in the background.  When the
Focus moves from the main Form to the Subform, the Record bound to the main
Form is automatically saved.  Similarly, the Record in the Subform is saved
when you move the Focus from the Subform to the main Form.

You cannot disable this AutoSave feature.  Hence, what you wanted cannot be
achieved through the normal use of the Form/Subform combination.

There are some work-arounds but they are fairly messy and involve a fair bit
of coding.

You may have to think of another strategy for data entry such as hiding all
the Subforms while the user enters the Record on the main Form and force
them to explicitly save this Record before showing the Subforms.

Alternatively, you can just create a normal Form for the "One" Record (in
the old main Form) and CommandButtons to go to separate Forms to enter the
"Many" Records (fr the old Subforms).

Signature

HTH
Van T. Dinh
MVP (Access)

> I have a data entry form that contains a couple of subforms.  I would lke the
> user to be able to enter all of the information on the form (including
> subforms) and then confirm the update prior to the records being saved.  Is
> there a way to do this?  I am not very good at code, but am sloooowly learn.
> Any help is greatly appreciated.  If I have not provided enough information,
> please let me know.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.