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.

synchronize two forms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
hngo - 04 Aug 2005 04:06 GMT
Hi,

I have two forms one bound & one unbound.  The unbound form is used to
display the bounded form records in form format.  My problem is that the
unbound form only display the record during initial opening after that even
you select a different record on the bound form the unbound form record does
not change

please help

many thanks
David Cleave - 04 Aug 2005 14:09 GMT
Hi there

You need to set the bound form to copy its values across to the unbound form
whenever the bound form changes to a new record.

Create a routine from the bound form's OnCurrent event. (The OnCurrent event
occurs whenever you change to a new record, or when the form opens.) Do this
by going into the bound form's properties, clicking the Events tab, selecting
the box saying 'OnCurrent', clicking the little button with the three dots,
and choosing 'Code Builder'.

In between the Sub and End Sub lines, type what you want to happen when you
change record. To copy the value from Text Box 1 in Form 1 to Text Box 1 in
Form 2, type the following:

[Forms]![Form 2]![Text Box 1] = [Forms]![Form 1]![Text Box 1]

Repeat for all the other controls on the form.

You might also want to update a control on the unbound form whenever the
corresponding control on the bound form is changed. You will need the
control's AfterUpdate event for this.

Hope this helps

David

> Hi,
>
[quoted text clipped - 7 lines]
>
> many thanks
 
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.