Access Module Code: rst.movenext I assume... (Resolved in the nick of time)

[Matt_T_hat]

Presumably it is perfectly simple to open an SQL statement OR a Query and then move through it record by record until EOF thus doing something with each value.

In this case I shall be wanting to do stuff to a word document dependent on the data.

My question just boils down to this:

I understand that I will be using this structure

If not EOF then
Do
Open the SQL/Query (somehow) into some object or other
result = function_to_do_stuff(object.rst.field("foo"))
result = function_to_do_stuff(object.rst.field("bar"))
object.rst.movenext
loop untill EOF
end if

BUT what syntax, words, objects etc am I to use... basically I have no idea of the correct use of the language in this instance.

Could someone post some actual code in order to get me going in the right direction?

BTW: the code will run in a module

[edit]Or a pointer to an article or anything just need to start[/edit]