hi mmcdonal,

yes i did. I manage to figure out what's wrong with it, after some testing and reading. the declaration of the recordset should be: Dim rsUser As dao.Recordset

For me, the error message don't seem to represent the error itself. Thanks.