L
laser02910
because a related record is required in table 'Company'.
I'm still new to Access but learning.
I've basically taken the "Orders Form" from Northwind (to include the
subforms and queeries) and changed it to fit my needs. My Ordersqry is based
on 3 tables- Companytbl, ShipTotbl and Orderstbl.
The ShipTo info, on the form, is filled in with the Company address info (as
a default) when I select the Company from the combo box.
Everything works fine until I go to the subform to select the products.
That’s when I get the "You cannot add..." error.
I don't understand why I get this error since the forms Company info comes
from what is already in the table. Could someone please point me in a
direction?
I'm still new to Access but learning.
I've basically taken the "Orders Form" from Northwind (to include the
subforms and queeries) and changed it to fit my needs. My Ordersqry is based
on 3 tables- Companytbl, ShipTotbl and Orderstbl.
The ShipTo info, on the form, is filled in with the Company address info (as
a default) when I select the Company from the combo box.
Everything works fine until I go to the subform to select the products.
That’s when I get the "You cannot add..." error.
I don't understand why I get this error since the forms Company info comes
from what is already in the table. Could someone please point me in a
direction?