I am not sure why this is happening.
When I typed in the lines below, I wasn't given the option of Database after the As sentax. Now I am getting a Compile Error, User-Defined Type not Defined.

Any Idea why?

Private Sub cmdAdd_Click()

        Dim dbs As Database, rst As Recordset

It depends on what references you have, for example ADO or DAO.
Acc97 comes with DAO as default
Acc2k comes with ADO as default

So make sure you've got your references in order

If you're using DAO, try
Dim dbs as DAO.Database

If you're using ADO, try
Dim dbs as ADODB.Database

HTH

Steven

I am a loud man with a very large hat. This means I am in charge