Unable to update form

[peter]

Modify the record source of the problem datasheet in the
following way.
-make all joins 1 to 1
-index or key all fields that are joined

I've seen this problem before and this fixed it. Hope it
works for u2

 

[TBock]

Thanks for your feedback but I cannot make the joins a 1-
to-1 as I have multiple orders for each customer. I will
try setting the primary key value and indexing the fields
to see if that makes any difference. Thanks again!