A question about Recordsets

[kurtis51]

This is possibly a silly and simple question about recordsets. When does one use them? Should one use them for every table they create or for one main table?

All of the books that I've read have said to use them, but in what context does one? I'm just drawing a blank on this...

 

[kurtis51]

Sorry wrong section :S

 

[gemma-the-husky]

generally you can use queries to get info from tables

sometimes a query wont quite give you what you want, or its unnecessary and there are one off functions like dlookup, dmax to find selected bits of information.

However if you want to examine every item in a query result or table, line by line, then you need ot step through them a line at a time - this is what a recordset is used for

the pseudocode is something like

openrecordset
repeat
    examinerecord
    goto nextrecord
until endoffile
closerecordset