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

Tip: Looking for answers? Try searching our database.

Two subforms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
C Tate - 17 Apr 2008 23:12 GMT
I recently created a main form in the style of the customer order form in the
Northwind database. It has two subforms and I've linked them together so when
you click on a line in the first subform, the relevant records appear in the
second.

This is a very convenient way for me to look at my records. What I was
wondering is this: is there any good reason why I shouldn't use this method
for data entry? I've tested the forms and everything seems to work ok.

I just wondered why none of the books seem to suggest this method (or at
least the ones I've read!). Thanks in advance.
ruralguy - 18 Apr 2008 02:22 GMT
It is a perfectly valid method for data entry.  I've used that method for
years. I usually put a delete control on the right SubForm so a single record
can be deleted.  It is important that you have Referential Integrity enforced
so there are no orphaned records.

>I recently created a main form in the style of the customer order form in the
>Northwind database. It has two subforms and I've linked them together so when
[quoted text clipped - 7 lines]
>I just wondered why none of the books seem to suggest this method (or at
>least the ones I've read!). Thanks in advance.

Signature

RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

 
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.