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 / February 2008

Tip: Looking for answers? Try searching our database.

Linking Subforms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Melinda - 01 Feb 2008 18:05 GMT
I am writing a Real Estate Database which consists of several tabs on a main
form.   All the tabs are linked together by PK, PIDNo.     What is the best
practice when trying to edit the subforms?  In some instances I have a
mainform, subform, and a second subform.   Please advise
BruceM - 01 Feb 2008 18:14 GMT
Do you mean a subform has a subform of its own, or that the main form has
two subforms?  Are the subforms on the tabs?  I'm not sure what you mean by
"best practice".  It depends on what you need to do.  Is there as specific
problem?

>I am writing a Real Estate Database which consists of several tabs on a
>main
> form.   All the tabs are linked together by PK, PIDNo.     What is the
> best
> practice when trying to edit the subforms?  In some instances I have a
> mainform, subform, and a second subform.   Please advise
Melinda - 01 Feb 2008 18:55 GMT
I have one main form, with several subforms, owners, revision, etc., etc. on
individual tabs.    The subform "owners"  has another subform, "parcels" form
in it.   After I enter the data into the owners subform and I then want the
option to go back and make a correction to a parcel on another day what is
the best way to edit the subform within the subform?    

> Do you mean a subform has a subform of its own, or that the main form has
> two subforms?  Are the subforms on the tabs?  I'm not sure what you mean by
[quoted text clipped - 7 lines]
> > practice when trying to edit the subforms?  In some instances I have a
> > mainform, subform, and a second subform.   Please advise
BruceM - 01 Feb 2008 20:49 GMT
Why not just navigate the subform until you get to the record that needs
editing, and change it?  Are you asking how to find a particular record in
the parcels subform?  Is there a relationship between the main form's record
source and owners, and between owners and parcels?
Some description of the database's purpose (just an outline for now) would
be helpful.

>I have one main form, with several subforms, owners, revision, etc., etc.
>on
[quoted text clipped - 18 lines]
>> > practice when trying to edit the subforms?  In some instances I have a
>> > mainform, subform, and a second subform.   Please advise
 
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.