>Can't you just use
>
>.Open "SELECT * FROM unit, unittype, estate WHERE untestateidno = estateid AND unttypeidno = unittypeid", myConn, adOpenKeyset, adLockPessimistic, adCmdTableDirect
No Chadd. You can't use adCmdTableDirect with a SQL Query!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com