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 / May 2005

Tip: Looking for answers? Try searching our database.

Update a sub form in a form!!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kennykee - 05 May 2005 11:46 GMT
I got a form and a subform

form = fruit , (field = Name)(combo Box)
subform = mass , (field = Weight)

Question : How can i run the (Weight_afterupdate) using (Name_afterupdate)
in VBA?

Let say the form and subform do not have the same source(subform inside the
form)

In short, what code to be used in the (Name_afterUpdate( )) to run
(Weight_afterupdate( )(subform))?

Any solutions?

Thanks in advance

Kennykee
Ofer - 05 May 2005 22:22 GMT
You can always create a function in a module write in it what ever you want
to happen on the after update of the weight , so you can call from both the
form and the subform.

> I got a form and a subform
>
[quoted text clipped - 15 lines]
>
> Kennykee
kennykee - 06 May 2005 02:20 GMT
Ermmm.. I am quite not understand what was the meaning of your instructions
Can you please just write a vba code for me for better understanding?

> You can always create a function in a module write in it what ever you want
> to happen on the after update of the weight , so you can call from both the
[quoted text clipped - 19 lines]
> >
> > Kennykee
Ofer - 06 May 2005 11:19 GMT
I'll try to walk you throug
Let say I Have a main form called Form2, and a subform Called Form1.
In the sub form I have a field called  mass and after I update that field I
Run a refresh on another field Called MyField
I'll create a function in a module
function aaa()
  Forms![Form2]![Form1].Form![MyField].requery
end function

in the after update of the field mass I'll call that function

Private Sub mass_afterapdate()
   aaa
end sub

I'll also call this function on the after update event of the field on the
main form.

> Ermmm.. I am quite not understand what was the meaning of your instructions
> Can you please just write a vba code for me for better understanding?
[quoted text clipped - 22 lines]
> > >
> > > Kennykee
 
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.