Oops . . . I was looking at that JOIN syntax and I realized that maybe it had to be "INNER JOIN" and indeed that seems to have fixed it.

>Creating a form to update an Access table . . . works great with a cursor adapter when I just have it pulling all records from that table. Does not work when I try to join to another table. I'm just using "standard" SQL syntax (ACCOUNT JOIN PAYMENT ON ACCOUNT.ACCTID = PAYMENT.ACCTID). When making this change to join the two tables, suddenly it won't work. Perhaps it's a syntax issue. Any help would be appreciated.