I have 2 forms: formA field1- Source(lookup field from Form B field Source) field2 - quantity formB field1- Source field2 - quantity I want to create a recordset where recordset = formA.Source == FormB.Source && FormA.quantity != FormB.quantity In other words, the resulting recordset would be populated with all records from FormA with matching Records in FormB on the Source field, and FormA quantity does NOT equal FormB quantity. Data FormA Source Quantity A 1 B 2 C 1 ----------- FormB Source Quantity A 2 B 2 C 2 ------------ The resulting recordset would be populated with Source A C ---------------- I can accomplish the task using a FOR EACH statement, HOWEVER I have to iterate through too many records and run into the 5,000 line execution limit.
Writer is a powerful online word processor, designed for collaborative work.