error 424 object required

[vanti1]

Sub addingrecords()

Dim MyDB As Database
Dim rs As Recordset

Set MyDB = CurrentDb
Set rs = db.OpenRecordset("Coursesffff", dbOpenDynaset)
'rs.AddNew
'rs("coursecode&quot = 998
rs.Close
MyDB.Close
End Sub

code to add a record to a table called coursesffff produces the following error (object required error 424) any ideas guys??

thanks as always
mike

 

[ghubbell]

Hi Mike,

Dim intMikesNumber as Integer
intMikesNumber = 998

rs!coursecode = intMikesNumber

should get it to go... Gord
ghubbell@total.net

 

[petermeachem]

These two lines
'rs.AddNew
'rs("coursecode&quot = 998

are commented out?

Didn't get the point of the previous post at all.