Type mismatch error

M

mike

Hi All,

I'm getting an error while inserting into a table.

The code is:
Dim db AS DAO.Database
Dim AddComp As Recordset

Set db = CurrenDb
Set AddComp = CurrentDb.OpenRecordset("Computer",
dbOpenDynaset)//Error Type MisMatch

With AddComp
.AddNew
!ComputerName = Me.ComputerName
.Update
End With

Thanks,
mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compile Error: Type Mismatch 3
Recordset in Access 2007 1
data type mismatch 4
type mismatch 1
access visual basic program 'type mismatch' error 1
Remove Identical words 0
Type mismatch and reference 2
Overflow error 6 3

Top