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 / Modules / DAO / VBA / September 2007

Tip: Looking for answers? Try searching our database.

Need help with Syntax to call a Parent form function from a module

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Al - 24 Sep 2007 16:14 GMT
This is the code I extracted from one of the subforms which works correcly.
   lngResult = Me.Parent.UpdateDASubform()
    Me.Parent![DASub].Requery

What is the correct syntax to call this function from the update module?
I have tried this which doesn't work:
    lngResult = Form!DAMaster.UpdateDASubform()
    frm!DASub.Requery
Ofer Cohen - 24 Sep 2007 16:52 GMT
Try

Form_FormName.SubName

change the FormName and SubName to your objects names
Signature

Good Luck
BS"D

> This is the code I extracted from one of the subforms which works correcly.
>     lngResult = Me.Parent.UpdateDASubform()
[quoted text clipped - 4 lines]
>      lngResult = Form!DAMaster.UpdateDASubform()
>      frm!DASub.Requery
Al - 24 Sep 2007 18:24 GMT
Thanks that worked.

The commands now are:
           lngResult = Form_DAMaster.UpdateDASubform()
           frm!DASub.Requery

> Try
>
[quoted text clipped - 10 lines]
> >      lngResult = Form!DAMaster.UpdateDASubform()
> >      frm!DASub.Requery
 
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.