:( It says that to get rid of a "type mismatch" error I should add the DAO.lib. But I already had it and I always got the error.

Set oSQL = "SELECT * FROM TableInfo WHERE Caption Like '" & strTarget & "'* "


The last ampersand is the type mismatch.

the star/wildcard should be within the quotes, should it not?

edit: clarification: it should be within the single quotes, i.e. :

strSQL = "SELECT * FROM tblSomething WHERE Field LIKE '" & strTemp & "*';"


i think that would cause a type mismatch..

Thank you :)

your welcome :)