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 / July 2007

Tip: Looking for answers? Try searching our database.

Refresh a value pulled from another form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CW - 15 Jul 2007 10:16 GMT
I have a read-only control (InsuranceVale) on a tabbed sub-form that
references and displays the value that has been entered in a similarly named
control on my Main form. (Thanks to Arvin Meyer for helping with this).
If I enter a value on the Main form and then move to the sub-form, the value
is not displayed. Clicking on Save doesn't seem to help. It seems as though I
have to exit back to the switchboard for the change in value to become
effective in the sub-form.
I guess I need something in the On Change or On Exit property of the control
on Main (??) but I would appreciate advice on this, please!
Many thanks
CW
Ofer Cohen - 16 Jul 2007 07:06 GMT
As you move from the Main Form to the SubForm the AfterUpdate event of the
main form is triggered.

Use that event (AfterUpdate of the main form) to refresh the values in the
combo in the sub form

Me.[SubFormControlName].Form![ComboName].Requery

Signature

Good Luck
BS"D

> I have a read-only control (InsuranceVale) on a tabbed sub-form that
> references and displays the value that has been entered in a similarly named
[quoted text clipped - 7 lines]
> Many thanks
> CW
 
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



©2009 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.