I just converted an app from 2007 to 2010 and the module line "set mdb as database" doesn't work. I receive the message, "Compile error: Expected user-defined type, not project". What's the new code for 2010?

It is unfortunate that I just haven't taken the time to learn 2010, but no time like the present, huh?

Try:
and check that you have the necessary reference in your project.

Thank you for the quick response, it worked great!

You're welcome!

How about Rs.recordcount? Doesn't work either... (rs being a recordset of course, but you already knew that).

When you say "does not work", do you mean that you receive an error (if yes please specify the error number and message) or do you mean that it does not return what you expect ?

Compile error:
Method or data member not found

dim mdb As dao.Database, rs As Recordset
Set rs = mdb.OpenRecordset("cwa_pendingreports")
If rs.RecordCount > 0 Then
DoCmd.OpenForm "cwa_pendingreports"
End If

Try:

thanks again!! Everything seems to be working now.

You're welcome!