I typed in the sample code starting on pp 135 to help me understand the DAO. When I try to run it, the code errors on the statement set dba= CurrentDb. Message is: Run time error #13-Type mismatch. Which suggests to me that I'm trying to set the variable "dba" to something other then a database as the variable is dimensioned for. Any idea what I'm doing wrong to cause this error? How can I correct it.

I don't have a copy of the book with me as I'm interstate at present, so I can't check what's written on the pages you mention.

The syntax set dba = CurrentDb is correct (although I don't recall actually using the letters "dba").

Check to make sure you have DAO referenced. Open any code module, and select References from the Tools menu. If Microsoft DAO 3.6 Object Library is not selected, find it and select it. If it's marked as missing, unselect it, find it and select it again.

If that's not the problem, please post the entire procedure as you have it in your program, and I'll take a look.

Graham R Seach
Microsoft Access MVP

That solved the problem. In the References library the DAO 2.5 instead of 3.6 was selected. When I unselected the 2.5 library and selected the 3.6 the problem went away.