myQry=" SELECT * FROM unit, unittype, estate WHERE untestateidno = estateid AND unttypeidno = unittypeid"
With rstUnit
.index = "-----"
.open = " "
.recordsource = myQry
End With

u didn't specify whole the problem but i think i should be as above.
rafiq_1398@yahoo.com