Subform with an auto #

[Guest]

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.

 

[tina]

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

 

[Guest]

I check the table and made the change on the foreign key field, however, it
did not fix the problem.

 

[BruceM]

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.