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 / New Users / January 2008

Tip: Looking for answers? Try searching our database.

Forms not working

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Neil - 13 Jan 2008 23:07 GMT
I have created a simple 4 table DB and I am now trying to set up a form to
enter data, I am having problems as when I select all the fields I can only
enter data in to some of the fields.... ie if I create a customer address
form it works and a product form that works and an order form that works but
if I create a single form for all three as that covers the info on an
invoice the form wont let me enter say the product info. any help would be
appreciated
George Nicholson - 13 Jan 2008 23:34 GMT
You need to incorporate subforms. One simplistic approach might be:
OrderHeaderForm
   CustomerID
           -Customer subform (Customer detail)
   OrderID
           -OrderDetail subform (Products, and Qty Ordered)
   OrderDate
   Salesperson

Signature

HTH,
George

>I have created a simple 4 table DB and I am now trying to set up a form to
>enter data, I am having problems as when I select all the fields I can only
[quoted text clipped - 3 lines]
>invoice the form wont let me enter say the product info. any help would be
>appreciated
 
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.