Type mismatch error

  • Thread starter Thread starter mike
  • Start date Start date
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
 
Back
Top