Hi,
how I can insert this SQL statment :
" SELECT * FROM unit, unittype, estate WHERE untestateidno = estateid AND unttypeidno = unittypeid"
TO this RecordSet :
With rstUnit
.Index = "PrimaryKey"
.Open "unit", myConn, adOpenKeyset, adLockPessimistic, adCmdTableDirect
End With
Many thanks
adsc
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>