(
I'm running win98 and Access 2000)
http://www.mvps.org/access/modules/mdl0004.htm


still looks like what I want to use and I've done -

"You need to set a reference to DAO. While in the VB Editor, click
Tools -> References..., locate the list entry for

Microsoft DAO 3.6 Object Library

and put a check mark in the box next to it. Then close the dialog.

Also, where you see the declarations in the code:

Dim db As Database
Dim rs As Recordset

change them to

Dim db As DAO.Database
Dim rs As DAO.Recordset"

but things still don't work - no data is being picked up.

Attempting to debug shows that the line -

Set db = CurrentDb

does not get set. Is there something else that needs to be set first so that
CurrentDb will work?

thanks again!
Michael Slade