Alex.  Did some investigating, and I believe that I know what is causing the problem, but have no idea how to correct it.

I have a combo box on this TestOrderF form, which pulls a number of fields from query "CreditCardDataQ", and then as an after update macro inserts that data into fields on this form which are from the "TestOrderQ' query.   The idea is to pull available credit card data for the customer that applies to this order record, and store it in the order.

The query "CreditCardDataQ" does include a CustomerID field with the criteria:

Forms!TestOrderF!CustomerID

which is supposed to select the records that match the customerID.

Any thoughts?

---

Reply from Alex Hedley:

Is the CustomerF still open? Do you open the OrderF from the CustomerF.
If so change your criteria to reference Forms!CustomerF!CustomerID instead