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

Tip: Looking for answers? Try searching our database.

Error 3201

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
iam5tv@gmail.com - 29 May 2007 14:47 GMT
Hi

I am making a simple sales database. I'm not too up with Access but
I'm finding it hard to figure this out.

Basically there is a customer form where you enter name, address etc.
This has the Customer ID from the table which is the primary key. I
have a command button which should take this customer ID and put it on
the Orders form. This works but after I add data to the orders form
and click into the order details subform, it shows the Error 3201. If
I remove the copying of the key and type it manually into the orders
form, there is no error.

Help!

Thanks
NetworkTrade - 30 May 2007 00:18 GMT
since no one has jumped in to help

you have a customer form - so your example is a new customer because you
complete this form - - - but kind of implies that you could have a repeat
customer and could simply look up their data rather than enter it.....so
there is a customer table I guess

the only point to this is whether you have locked together the customer form
- orders form - order details form  ;   somehow illegally when you do a new
customer....since you say it works ok when you type in the info ....

the Orders form/table would have its own unique order ID key for each
record....and this Order form/table record only needs the unique customer ID
for cross reference to the Customer table.  So you have a customer ID field
in the Orders form/table but it is not the key - only for cross reference...  
A typical design would be to use a combo box in the Orders Form that sourced
on the Customer table to look up the customer and that selection puts their
ID into the customerID field in the Orders Form.....

then of course the Orders Details form/table have their own unique detail
IDkeys and each record here has the Order ID key field but not as the
key...only for cross reference....  Presuming this is a subform to the Orders
form and you have the ID cross reference selected by the wizard when you
inserted this then the relationship is already there....

Signature

NTC

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