How to get more records from table and getting them with DAO?

[ahmadbaseet]

Hello,
How can I get more records with DAO.
I write
Dim rs As DAO.Recordset
'selecting data through SQL then
with "rs("Fieldname")"
I can get the data if only 1 row is back from SQL query. How can I write if I get more than 1 row from table. is it like this
with rs(0,"Fieldname")
please reeply as soon as possible, Thnaks in advance

[Stwange]

Hello,
How can I get more records with DAO.
I write
Dim rs As DAO.Recordset
'selecting data through SQL then
with "rs("Fieldname")"
I can get the data if only 1 row is back from SQL query. How can I write if I get more than 1 row from table. is it like this
with rs(0,"Fieldname")
please reeply as soon as possible, Thnaks in advance

Try using rs!fieldname for each field in a row.
Then, when it comes to move to the next row, just use:
rs.MoveNext
Hope this helps.

[ahmadbaseet]

Try using rs!fieldname for each field in a row.
Then, when it comes to move to the next row, just use:
rs.MoveNext
Hope this helps.

I will try this, but if u have any other idea plz write that also. Thanks a lot.