>>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!
Exactly ... you can't, Otherwise my problem should be solved.
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>