<< As a side note, per ideas from this list, I tried something like EDI USINGFromName WHERE CUSTID IN (150, 121, 208, 161,117) - all the Smiths by alphafirst name. But the EDI automatically sorts the CUSTID. Is there a wayto disable sorting so editing occurs in the given sequence? >>
Doug, I think you're confusing the WHERE clause and the ORDER BY clause. The syntax you gave above deals only with the selection of records for inclusion in the form's recordset. If you want an order you have to state it explicitly: WHERE CustID IN (150, 121, 208, 161, 117) ORDER BY FirstName If the form's table doesn't include the FirstName column, you can't do the ordering. In that case, you either need to base the form on a view that does include the FirstName column and then link the actual, editable table (since the view will not be editable) into the form as a secondary table or else project out the table you want to edit into a temp table, add the FirstName column and update it from another table, perform the edits in the temporary table, then post them back to the real table when done. -- Larry
