 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2007Subform with an auto #
I have added a subform for purchase orders to a main form linked by customer name. Directly from the subform I can add new purchase orders, but when it is linked to the main form, it will not allow me to add a new purchase order. It is set to allow additions.  SignatureRonnie open the purchase orders *table* in Design view, and click on the foreign key field that links the table to the customers table. look at the field properties at the bottom, and make sure that the Indexed property is *not* set to Yes(No Duplicates). if it is, change it to Yes (Duplicates OK). hth > I have added a subform for purchase orders to a main form linked by customer > name. Directly from the subform I can add new purchase orders, but when it is > linked to the main form, it will not allow me to add a new purchase order. > It is set to allow additions. I check the table and made the change on the foreign key field, however, it did not fix the problem. SignatureRonnie > open the purchase orders *table* in Design view, and click on the foreign > key field that links the table to the customers table. look at the field [quoted text clipped - 9 lines] > > linked to the main form, it will not allow me to add a new purchase order. > > It is set to allow additions. Verify that the relationship between the two tables is correct. If it is, in form design view click the subform once to select the subform control (the subform control should have a sort of border around it with handles in the corners and in the center of each edge). Click View > Properties, click the Data tab, and be sure the Link Parent and Link Child field contain the correct value. If they contain no value, click the property and click the three dots. A dialog box should appear with suggestions. While you're on the Data tab, be sure the subform control's Locked property is No. >I check the table and made the change on the foreign key field, however, it > did not fix the problem. [quoted text clipped - 15 lines] >> > order. >> > It is set to allow additions. |
Reply to this Message |
 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.