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 / Forms Programming / August 2005

Tip: Looking for answers? Try searching our database.

Refresh one form from event on another?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dean Slindee - 04 Aug 2005 18:42 GMT
I would like to trigger the refreshment of one form based on insertion of a
record in another form.

Both forms have the same table as the datasource.  The first form is a data
entry form (with text boxes), the second form is a datasheet view of all
rows in the same table.  I would like to refresh the datasheet form when a
new record is added on the data entry form.

Can this be done, and how, which event?

Thanks,

Dean Slindee
Marshall Barton - 04 Aug 2005 22:05 GMT
>I would like to trigger the refreshment of one form based on insertion of a
>record in another form.
[quoted text clipped - 3 lines]
>rows in the same table.  I would like to refresh the datasheet form when a
>new record is added on the data entry form.

Use the first form's AfterUpdate event to requery the second
form.

    Forms!sheetform.Requery

Signature

Marsh
MVP [MS Access]

 
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.